This seems to be a problem but I cannot figure out why...
SELECT qryEmpDates.EmpFirstLast,
DateAdd("yyyy",[YearsOfService],[dateOfHire]) AS EmpAnniversery,
DateDiff("yyyy",[DateOfHire],Now()) AS YearsOfService,

I am importing large, 60 field 300,000 record csv files and am quickly
overloading Access.  I need to query each table, once imported (all fields as
text), to find which field are all or mostly null or ZLS.  Then I can delete
these fields.  So, I need a query that results in just ...

I've entered the following expression in a query:
TotalPay: ([Pay/CH]*[CreditHours])+[TravelAllowance]+[PayAdjustment]
The query doesn't return the resulting calculation.  What am I doing wrong?

I am using Access 2003.
I have a query in which I want to search for records that include a date
field that is empty.  I tried - isnull  - but that did not work.  I must be
having a senior moment because for the life of me I can not think of how to

Now I am thinking with all the experts in here, I am wondering if anyone can
help me with a formula that can calculate just the selective range of data of
a certain date. Based on initial problem I stated below, I have to make a
query that filter out only records of a certain date, ...

I have the following expression in my query :
Expr1: [ddu]*[size]*[Quantity]
Can you hlp me build an IIF with the following condition :
If size < 1 then  [ddu]*[size]*[Quantity]"2

=IIf(DCount("*","UM Files","[13] IN  ('Y','N')
AND [Review Date] =#" & [Enter Date] &
"#")=0,"N/A",FormatPercent((DCount("*","UM Files","[13]  ='Y' and [Review
Date]=#" & [Enter Date] & "#")/DCount("*","UM Files","[13] IN ('Y','N') and

I am using the following on a Query, In this I would like to see a projected
days and a actual days. I am seeing all entries on the chart though. I only
need the 2. Could someone please assist? The projaccdays = projected days and
actdays = actual days.

Can someone give me a simple expression to print the weekend date in a report
based on the date of the information entered in the details. I will have
daily reports but the invoiced cleint wants the weekeend date as well on top
of the daily reports.

I am looking to create unique records and combine donation totals which look
like this:
Donor ID  Donation  Participant   Donor
1234        $50        Ray Day       Mike Lewis

WWW.SWEETSAUCE.BIZ
More Software, Better Savings

My Brain is fried and I lost my book...
I have data from an outside source that is not really user friendly, but now
I have a way to update several tables from that source.
The outside data is my most recent information, and I want to append the

I have a square matrix of values that I'd like to re-format into a few
columns in order to better manipulate them.  I was wondering if anyone could
help me with this.
My data matrix is essentially a pairwise comparison of similarity values

I have a crosstab query with parameter, when I run the query, the pop up
window by the access (not the parameter form I created),
Forms!ReportRange!Starting date, and so on...
I enter "starting date", "Ending date" and "programme" in th pop up window,

If I say 'SELECT TOP 5' and the result set returns less than 5 rows, do I get
an error?
I looked in Access SQL help and it did not say.