I need some help designing a query that calculates a specific date from the
hire date of an employee.  For example: an employee is hired on 05/13/08 and
3 months from the hire date they are required to take some sort of refreasher
class.  I want to create a query that I can run to ...

In a pass-through query we are calling a stored procedure. How do we pass
forms data as a parameter to the Stored Procedure.
I tried this
Execute spr_3abcdAddUpdtQueries([Forms]![ProcessDates]![StartDate] ,

while creating a query using a grid, what is purpose of using
"where" . This comes up when we use Totals.
can we use  a criteria just below the field which has "where" . Does
it work? pls help

Hello in a field of a table lets call it F1 of Table1, there is data entered
but with "spaces at the begining or the end of the text. And maybe more than
one "spaces". For example the word "Smith" is entered: "  Smith" or "Smith  "
or

If i create a Querry between two data tables is it possible for me to also
show the items that do not match. For instance I set up the relationship to
show all of the left side and only the table on the right side where it
matches the left side. But then also show only the items ...

Please see the SQL below of the queury I am building.  The queury worked
fine until I set criteria to count only fields that contain the word 'Over
Drawn'.  I get the message 'This expression is typed incorrectly, or it is
too complex to be evaluated'.

Good morning.
I posted this question yesterday, but failed to give a good description of
what I am trying to do.
The SQL below is my attempt to group a list of accounts (DepositingAccount),

I want to Append data from an existing table ( Safety supply transactions)
into a YTD table ( SUPPLIES USAGE YEAR TO DATE) including only new records
based new records added to Safety supply transactions based on the date.
Below is the SQL view of what I have set up.

I took an intensive Access 2003 course and have accidentally become the
expert at work.
I've built several queries in which I'll have to prompt the user to enter a
4-digit number. Now, I need to figure out how to connect that number with a

I have a query where I want people to be able to select the criteria from a
list (there are some criteria that have difficult spelling and if entered
wrong people get no results).  Right now the query runs with a prompt where
you type in the parameter, can I change this to a drop ...

LS,
I have to tables, say A and B.  For all records in A I would like to find a
corresponding record in B. Unfortunately I can not do this using a unique
key, so from all records in B that match I would like to pick the first.

Hi, i have gone through all the posts in this discussion group.
I need help with lables, i have records in a table like below
Orderno box qty
23456     5

ocity   dcity  client  paiddate   mode    wgt     cost
A          B      gpi       1/2/08      L        10     20000
C           D     ppg       2/2/08    T        27     18999
E          F      sunc      1/4/08    C       78        1111

I have the following query:
SELECT tbl_times.[Staff Name], tbl_times.Date, tbl_times.Productivity INTO
tbl_Leaguestage1
FROM tbl_times

I have a query which prompts the user for a date. I want to then use
the entered date twice without calling for the variable to be entered
again.
Query is