I need to calculate the elapsed time difference between two fields.  The end
result should be in the HH:MM:SS format.  
The fields, I'll call them DATE_TIME1 and DATE_TIME2, are currently masked
to be displayed as 2005/11/30 08:15:30.25, but the actual unmasked format

I need step by step instructions on how to get parameters for a query from a
form that is completed by a customer.
Your help will save me fropm insanity
Peter

Hello, I would be extremly grateful if someone could help me with this problem!
I have a single table with 2 columns and I need to sort the table into
patient records but the patient identifier also has associated data beneth it
until it gets to the next identifyier eg. 1234567891 ...

I know I can specify form and field names in the criteria of a query.
However, I can't seem to be able to specify variables in the criteria of a
query.
Is this not possible?

I have set up a form-based parameter query to search different fileds.  The
more fields a user fills in, the more specific the search.  My database
searchs a medical journal database.  A user can search by: AUTHOR1, AUTHOR2,
AUTHOR3, AUTHOR4, KEYWORD1, KEYWORD2, KEYWORD3, ...

I have been linking Excel spreadsheets to an Access database to update it,
for some time now.  All of a sudden, <g> I can't write to the linked
spreadsheet.
I may have done a microsoft update in the recent past, but I can't remember.

I've got a DB to track courses taken and completed towards a certification
program.  In order to see which classes I should offer in the upcoming year,
I want to query "who has not had [fill in the blank].  I have done this in
another DB I created using check boxes, but I ...

Please help me to know how to write an expression for a criterion which will
pull only records with a date over the past calendar year counting back from
now()

I have a form whose control source is a query.  When I try to add a new
record on the form none of the data fields will accept data.  I can't type
data into the field.   I went to the query itself and ran it then created a
new record in the query with the same result. I could not ...

I'm having a problem with a make table query.  What I am doing is creating a
table with a single text field from a combination of fields from another
table. I am then exporting this Table as a .TXT with a Fixed Width option and
using this file to process multiple transactions ...

I have 2 tables that contain the same fields.
I would like to get data back where Field 1 in table 1 and 2 (Account #) are
are the same but in Field 2 ($ Balance) it is different.

I am using Access 2003 version. I have completed a distinct query on 2 tables
and the results are fine but I need to separate the results by each table
from which they originated.

I have been working for several days now to try and query 2 different
databases into one table or output. I have a working query for each that
returns the data as expected. I seem to be having trouble getting the second
query to read 2 fields from the first query as criteria. I ...

I have a field which represents various dates meter readings were taken for a
customer.  I need my query to pull only the most reacent reading.  I can't
seem to figure out how to write the query to pull only the most recent date.  
Please help!

I want to make a query to find the differences in various fields for  
matching records.  For example, I have two tables with SSN as the PK.  I know
that the SSN's make a one to one match from table 1 to table 2, but what I
want to find are differences for a single SSN where on ...