I've got a query that I just can't seem to get right.
I have a table (orders) with itemName and itemQty. Every order makes a
new row so I can have many rows with the same itemName plus the
itemQty that was ordered.

I have a query I am trying to create based on another query
(inventory) and a table.  The inventory query shows the date, shift,
Die set and the # of shifts remaining for each die set in inventory.
The table has a corresponding date and shift field as well as two more

How do I average the field “Minutes” from the query “qryUrban” and display
the average in a report?
I would like to find the (mean) average, but I have no experience with the
AVG function.

access 2003 problem
SELECT * INTO [test_table] FROM [old_table] ORDER BY [PH_ORDER];
(PH_ORDER is a unique numeric field)
I thought this would be straight forward, but in some cases (particularly

I want to be able to create a run-time executable database that allows the
user to open the quesy in edit mode.  Any help would be great.  Thanks!

I have a query that asks for collcode, collcode2 and booth.  On any given day
an employee may be collcode or collcode2.  I would like to know how many
times a certain emp has been paired with another employee.  So how do I ask
if an employee has been collcode/collcode2 and who ...

I have three queries that have pulled data from one table and summed specific
data.  The three queries are named "Total Wires", "Total Journals" and "Total
P&I".  I'd like to pull this into one query with the account name in the
first field, followed by the three totals mentioned ...

I'm trying to create a query that shows items from one query but deletes
those items that are also in another query. For example, an item has been
checked-out, returned, and checked out again. Qry 1 shows the items that are
not returned yet, and that works fine, but Qry 2 shows ...

Hello -
I have several tables that use a time field. This field is formatted as
medium time - HH:MM AM/PM
However, some of the records in my tables are showing seconds HH:MM:SS and

I have a table ... tblRoutes that include the fields id, routeno, fairdate,
booth, collcode and collcod2.  I need to know if I can limit limit duplicates
on two fields.  The fairdate would have 38 booths, so the 38 booths will
repeat each fairdate but not repeat for a set ...

I am unable to delete a email I have received.  I just get a message saying
"an error has occurred".  Can anybody tell me what to do please.

I have one table with two 2 fields; one with the date, and another with the
time. I need to be able to capture data for a 24 hour period of time
beginning at 06:30 am in the morning and ending at 06:29:59 in the morning of
next day.

I am resubmitting this question since I somehow managed to delete it off the
discussion group...
I have 3 queries that I want to use for retrieving the Beginning Balance of
inventory up to a certain date, retrieving all Sales between two dates, and

I am having a problem doing something in Access 2007 that I was always able
to do in Access 2003. Let me give you an example. A simple table with three
columns, one is the autonumbered column for each record, the second is a
product name and the third we will call serial number. ...

hy all
i am trying to generate a random query to display a random record of an
access database.
i tried this one :