When i try to call the fuction i get a error I am using
CalcWorkDays([DateDiverted],[dtmEnd])
The error says The expression is typed incorrectly or it too comples to be
evaluated

I have two moderately complex queries (each one has at least 7-tables and
several more joins) that must be combined via a Union query.  The results
will be used in subsequent queries.  Writing and maintaining SQL for this
Union query is a last resort.  How can I keep my ...

hey all,
i have a query that displays vacation hours for an employee. when i run the
query is there a calculator like in excel, if i highlight the hours column it
will show the sum in the status bar below?

We have a program, written in Delphi, that is used to print out task lists.
We now have to use Access (company new standard) and have imported the data
into tables, but don't know how to get the listings
Table 1:

I am trying to figure out the function of "FIRST" in a totals query -
with little luck so far.  I think that my intuition may be getting in
the way.  
Using Access 2000.  I have an orders detail table (tbl_orders_d) with

I created a data base that has 1 main table and 6 sub-tables.  The main table
has the ID field as an auto number.  Each sub-table has the ability to have
multiple entries.  Each sub-table entry has a date completed field.  I am
trying to create a report that will query each ...

I created a simple query that for some reason is automatically hiding all
duplicate rows from the main table it is pulling data from [DTBsFY07]. My
objective for the query is just to add descriptions to that main table and I
do not want it to hide any duplicate rows. What do I ...

 I have a database that several tables (tbl113 , tbl114 , tbl115), each has
identical columns (DPGId , Description , serialnumber , columnlocation)
 How can I do a query that will produce all the DPGId's in the same columns
as well as Description's , serialnumbers and ...

I,m trying to count how many numbers, in a column, that have a value greater
than zero. Any ideas anyone

I have a query that will return the count of evente corresponding to a
specific employee based on their employee ID number.
This is the SQL from the query:
SELECT Count(*) AS Expr1

I notice that if a child is born on 2/27/07, for exampe, this formula
states that he is only 6 months on 10/1/07.  What is wrong with my
formula. The child turned 7 months on Sept 27th.
AgeYear: Int((Date()-[DOB])/365)

I entered this into a query. It says it is to complex or typed
incorrect.  Can anyone give me some suggestions?
Thank you in advance.
Paperwork Expires: IIf([ClassroomID]="Kool Kidz" And

I'm using an access query to attmept to see if somebody meets a specific age
requierement. I need it accurate down to the present day. I tried subtracting
a date/time field and the Now() function and then invoking the year()
function on the whole thng. This gave me dates in the ...

Stumped at this point.  I have linked to a table that I cannot update but I
need to update a checkbox in my query based on information in the linked
table.  
My fields

to prevent people modifying my table contents, I link to the tables with a
query whose Recordset Type is set to 'Snapshot'.
The problem is that when the users build another query using this 'Snapshot'
query, the data are editable again.