|
|
|
MS Access 2003 Query commands
Fri, 19 Dec 2008 01:12:13 GMT
I have a student table with 4 fields namely StudentName, FatherName, Fees and
DiscountedFees.
A father e.g. Ahmad Ismail in field 2, has three children namely Lamis,
Balqis and Hasnah. The fees for the term is$2000.00. How do I ,through a
Query calculate automatically the Discounted fees for the 2nd and 3 rd ch ...
|
Type mismatch in expression
Thu, 18 Dec 2008 14:19:01 -0800
I have a query named PPA2Q, based on a pass-through query "VOLQ". The fields
in PPA2Q are meter, prod_date, and max_acct_period (to pull the max
accounting date for each production period). I am then trying to create a
third query, joining PPA2Q with the original VOLQ in order to get the other
fields (dth ...
|
dates in table 2 fields need to be one field I can sort by date on
Thu, 18 Dec 2008 13:42:14 -0800
aHere's the problem data is coming from a very old legacy system! The date in
the import table is actually 2 fields one storing month/day no leading zero
example: january 15 = 115, one storing the 4 pos year example='2007' I need
to combine these in do a field a can sort by date on and display as a date.
I'v ...
|
Date Part Function?
Thu, 18 Dec 2008 21:34:49 GMT
Hello!
I have a query and a table...
queryONE
FieldYear
2007
2008
2009
tableONE
FieldDate
1/1/2007
5/7/2008
5/9/2009
6/5/2010
I would like a query to only return the "FieldDate" values where the year
matches a value in "qryONE", not sure how to implement the function directly
into my quer ...
|
Alright you formula wizards
Thu, 18 Dec 2008 13:22:06 -0800
Have a table
tblCapacity
fldID
fldEffDate
fldCap
When an ID has it's capacity changed, another record is added with the new
capacity and new effective date. So, ID 555 may have 3 records.
ID EffDate Cap
555 1/1/1995 9
555 4/1/2004 15
555 11/1/2008 11
I need a query that g ...
|
Multiple Queries
Thu, 18 Dec 2008 12:48:50 -0800 (PST)
Ok this is going to be hard to explain but i will try my best.
I have a table that has 65,000 records in. It contains data such as
job number, customer name, But it also contains fields called date1,
status1, date2, status2....all the way to 20.
In these fields are the history of dates when the job changed s ...
|
Difficult Query; Trying to Show only One Record for only Two Field
Thu, 18 Dec 2008 12:47:01 -0800
I am trying to figure out a way to set up a query which has many advertisers
per Sales Rep, but only one Sales Goal per Sales Rep. When I set the Field
â??Q4 Search Revenueâ?? to Sum or Group By, I see multiple (duplicate) results.
The same happens when I set the Field â??Total â?? Q4â?? to Sum or Group By. ...
|
|
|
Multiple Queries
Thu, 18 Dec 2008 12:46:31 -0800 (PST)
Ok this is going to be hard to explain but i will try my best.
I have a table that has 65,000 records in. It contains data such as
job number, customer name, But it also contains fields called date1,
status1, date2, status2....all the way to 20.
In these fields are the history of dates when the job changed s ...
|
Formula Problem
Thu, 18 Dec 2008 12:23:06 -0800
I have a table with 4 columns:
Review Date
STDID
File #
Answers
I want to run a query to calculate the % of Y/ Y+N for all the answers of a
specific standard (STDID) for a specific review date. Ignore N/A in the
denominator if the answer is N/A. If all answers for STD 2 is N/A then
return N/A.
For ...
|
concatenate fields into same table...
Thu, 18 Dec 2008 21:13:09 +0200
hi all
I am using a table RT_AM_appointment with two fields
date_appoiment and time_appoiment
What I want to do is to concatenate data like e.g.
01/01/08 11:00, 12:00, 18:00
10/01/08 12:00, 13:30, 14:45, 15:30
.... etc
I tried to use a function written by Dev Ashish on
http://www.mvps.org/access/mod ...
|
|
|
