I've written a generic query in Access that I'd like to prompt users for a
list of values.
I've been reading th following training course, but it only tells me how to
prompt for a single value or a range.

I've got the basic combo box set up which enables the user to start
typing a value and the combobox will attempt to guess the remainder of
the value and give a pulldown menu.
The basic SQL created by Access (plus an Order by which I added) is as

Hello all...
I have built a database to track various info about the personnel who work
for me.  It is 95% done, but I have gotten stuck with one final report.  I
need a report to show me which of my people have graduated a certain training

Here is my query:
INSERT INTO CartWeight ( WeightTotal, CartIDNumber, CartNumber )
SELECT
Sum(([Cart.Line1Weight]+[Cart.Line2Weight]+[Cart.Line3Weight]+[Cart.Line4Wei

I wrote a SQL statement as recordsource for a combobox, here it is:
SELECT PAZ.ID, PAZ.PAZIENTE, TBLVISITS.TYPE, TBLVISITS.DATA
FROM (SELECT ID, (COGNOME & ", " & NOME) AS PAZIENTE FROM TBLANAGRAFICA) AS
PAZ INNER JOIN TBLVISITS ON TBLVISITS.ID=PAZ.ID

I have a form where i would like to have people enter details for a
timesheet. i have columns called [Time on Duty] and [Time off Duty] and then
another comlumn which i want to calculate the total amount of time (in hours,
eg. 8.5 hours). i am not used to these kinds of ...

I have a card controlled entrance door which updates an access database every
time it is used. tblUsers contains everyone who uses the door, tblEvents
contains a log of every pass through the door. tblEvents.SubAddr contains the
direction of travel - 1 for entry, 2 for exit.

Can you set a particular criteria for an autonumber field for it to produce
in a report
Access 2003

I have the following (unnormalized, i believe) table:
tblProducts
   fldProductID
   fldProductName

How would I set up a query to filter records based on time and date? I need
to run a report that I can specify a particular date and also the time of
that particular day to another particular date and time of day. Example, I
need to know how many gallons of fuel were pumped from ...

I need help!  I have many records in my database but in my query, I only
want to see the last 3 or the last 6 or the last 9 or ......... My records
all relate to monthly records so if I ask for the last 3 records, I am
asking for the last 3 months of records. I want to set the ...

I have a question about running totals Have a table that has mixed
inforation. I have the sum query for the table with 12 columns, how do I
transferred this sum query total to a different table.
TIA

I have a table with sales history records. As usual we are constantly
changing product codes so I frequently need to consolidate the sales history
from an old item to a new item for forecasting purposes. I don't want to use
'find & replace' because if I refresh the sales history ...

I have a code table that contains a single character as the code, but some
are lower case and some upper case. Access 2003 seems to consider the lower
case and upper case characters as duplicates. I need to join to this table on
this code. Is there a way to tell Access to treat ...

I am trying to perform a calculation in a query (I believe this is the best
place to do it) which gives me the total number of trues in a true/false
field.  I have the following:
Sum(Abs([MyTrue/FalseField]))