I know how to create a parameter query, but is it possible to get the dialog
box that it invokes to display a drop-down list of potential values instead
of requiring the user to type in a value off the top of their head?  ...maybe
get the values from existing entries in the ...

Does anyone know how to do something like this in Access 97?
UPDATE tableB SET
       date_ferment_completed =
                  EXISTS (

I have a table that I need to add a column that shows the time difference(in
minutes) between records.
ID    date
1    4/15/06 11:30 PM

Assuming I have 2 tables.
t_sexes
sex_ID    Sex_Name
1              Male

I have a report that I want to use from 2 different forms and have added in
the criteria section:
[Forms].[frm1].[CustID]
or

Can anyone tell me how to create a table a table with an autogen field?
I can do this to create a table
CREATE TABLE Employee
(

In one table I have a transaction date, in a second table I have the closing
dates for the accounting periods.  In the same table as the closing dates I
have the fiscal month and fiscal year that represent the closing date.  In a
query I would like to pull in the fiscal month and ...

Assuming I have 2 tables.
t_sexes
sex_ID    Sex_Name
1              Male

I am trying to run a query that lists all my clients, their invoice totals,
and total payments thus far.  I have created two separate queries.  Once
totals up the invoices and the other sums up the total payments fine.
However when I try to run them together, it only returns the one ...

I have been browsing around here looking for a solution to this problem for a
bit now and thought I might just try asking directly and see if someone can
point me in the right direction.
The database I am querying details patrols performed by our crews over a

I have three queries.  
First one:  "Discrepancies in unit price":
SELECT Data.MANUFACTURER, Data.[MFG #], Data.DESCRIPTION, Data.[UNIT PRICE]
FROM Data

I want to filter my data to return information for a specified date and for
the previous 14th Day, 28th day, etc for the previous 6 periods. i.e.
28/11/06   data
14/11/06 data

I am calculating the amount of time that an employee is tardy.  I am using
the following expression: TardyTime:
Format([ATIME]/1440)-([SHSTART]/1440),”h:nn”).  The problem I have is that if
an employee punches in early the expression doesn’t return a negative amount

I receive the error message in the subject line when I try to run the
following SQL
ALTER TABLE tblProgDeliv ADD COLUMN [TechID] NUMBER [LONG INTEGER]
TechID would be a foreign key to the Tech table, where it is the primary

How can I build a query to return Jack from the following from two tables?
[ie pull only the records in the parent table with ALL related children
records t/f field equal “true”]
Table1 (parents)