I am running a query that calculate the difference between two times and I
would like the results in h:mm format
If the difference is 2.5 days,  the query returns 12 hours, but leaves the 2
days off.

My understanding was that if in a query I write:  Between[Enter
Beginning Date]And[Enter Ending Date] that the result would be
everything between and including the two dates.  For example.
Beginning Date = 04/01/2007 and Ending Date = 04/15/2007.  I would

For some reason I can not get this LEFT JOIN SQL to work.  According to the
SQL below I should only see one Ticket# from the TroubleTicket Table, but
when I run this query it shows a Ticket# for every Action#.  Can someone tell
me what I am doing wrong?  I have done this several ...

I have a query setup to select specific information based on the month and
year entered on a form and stored in a table.  When I am prompted to enter
the month or year the parameter value message box says "Months!Month" or
"Years!Year".  Is there a way to customize this message ...

Is there any way to create a row number in a query?  For in example, in Excel
you can just do a =ROW() to get the row number, anything like this in Access?

Here is what I am trying to do and  I am not sure how to exactly go about it.
To simplify things I am using a basic example. I have a form where a
selection is being made, in this case food. based on the selection from the
form easy enough. However if "Pizza" is selected I want ...

I have a query which has only fou fiels per entry.
COST    COSTVAT    LABOUR    LABOURVAT
These fileds are all calculated fields in a query
if the Cost is £10.00 the CostVAT is £1.75

I want to turn off the violation error shown after I run an append query. It
displays due to key violation; which is what I wanted, but I do not want the
error pop up from displaying.

I am in process of converting some data into a more usable format. I need a
query that will add a leading 0 if there are less than 5 characters ie
change 1111 into 01111.
Table is Employee Field is EmployeeNumber. Access 2002

I've run into a snag of my own making and I'm hoping for some help...
I've been working on an ad-hoc database in Access 2002 and I've
created a large number of queries using semi-descriptive names - one
example is a query that's actually called

In design view of a query, what will be the output difference in the
following photos? What will happen to the data if I put the other criteria in
the "Or" column? Please click link. Thanks a lot guys!
http://i33.photobucket.com/albums/d98/archico01/qry.jpg

i am using access 2003 with frontpage 2003, and i have set up the
following query
SELECT [movies data].actor1
FROM [movies data]

I have a field [email] that contains email address in standard format
(handle@domain.com).  I need to pull the handle out of that string.
Is their an update query I can run to do this?

I have a table with a field where the data is a calculated value.  The
original query's field looks like this:
calcUnitTotalFBM: ([Thickness]*[Width]*[calcUnitTotalLength])/12
Originally, I have this calculated value entered in the actual field in the

I'm not sure if this question pertains to queries, but I need answer before
proceeding to forms or reports.  Let's say I have a list of part numbers
LNOKW11A
LNOKO23B