I need to create an expression for the following:
I have an age report that has to tell me which computer is ready to be
replaced.  the computer has to be older than 5 years.  so how should I write
the expression.  In my table I have a field of purchased.  Thanks

I have a palms table that stores palm census for each and every palm
for a block on every trial.
Every trial has a set number of blocks and set number of palms.
Each of the palms has a palm census done every year to check its

Is there anyway to produce a running total in a query?  I tried the
help menus but they only mention running totals in reports.

I am trying to run an append query, but it errors out at "Duplicate output
destination 'EmployeeID'."
I have checked (and re-checked), I see no duplicate fields except in the
original tables (where the info is pulled from for query).  

I have created a table such that it contains the records that should
be present that are not in the "real" table.
eg.
Area Block Tree

I am having trouble selecting a number of entries from a table, to include
in a report.  The criterion is that the date is the last which occurs before
the end of the month and which relates to a particular job.  I assume I need
to use a domain aggregate function to do this, but ...

I have Table1 with field Track, I want to update with info from field Track
in Table2
add both tables to design view field track but don't know what to put in
update too.

How do I set up a query so that I can pull all of a givin record and no more.
Example - one of the fields is Drawing number.  There are several drawing
numbers and numerous lines with the same drawing number.  I want to pull up
all of the records for a single drawing number.  If ...

I know how to enter a parameter prompt each time someone enters a query to
prompt them to type in something.  i.e. put [Please Enter Name] in the
criteria portion.  However, is there a way to prompt them with a list of
choices?  i.e. all the Names and they can click on the one ...

hey everyone, trying to figure out how to work this:
i have a form for where there is a Company field.  This control is a
combobox.  
there are 2 tables that both contain company names.  what i want to do is

I need to see if there is a way to assign a sequence number to a particular
record within a query.  For example...If an employee was hired multiple times
(hired / termed / then hired again), I need to count each hire on an
incremental basis.  Below is an example of what I'm ...

I can't seem to get the syntax correct with trying to add Nz function
to the following.
Tax: Sum([Invoice Detail].[id_SalesTaxRate]*[Invoice Detail].[id_Ext])
How do I add the Nz function to id_SalesTaxRate and id_Ext in the

The table has a field that contains a star (*), which probably also is a
wildcard in Access language.
Anyhow, I want to use the star as a field critera, but not very surprising
it doesn't work as intended... instead of ONLY showing records with a stat

I have a series of dates, which i want to group themselves into say weeks, so
i can use the weeks to calculate weekly averages.
I've been cirlcling round trying to find this function,
Either I'm having a blind moment or I need your help...eitherway i need your

TIA very much!
Is it possible to change an existing query object's criteria via VB code?
If so how might it be done??
Thanks again,