I am confused as to how to do this function in Access.  I want to create a
table which is built from an existing table.  The main difference I have is
to separate the data out in the PO_ITEM_NBR field.
Current

The following sql query returns a good result except some of the enteries do
have a business address and I will be using the query to produce labels.
What I would like to do is if the BusinessAddress1, BusinessCity,
BusinessState and BusinessPostalCode are blank then use the Home ...

Can anyone help me understand the solution for the question titled "Assign
Random Number to a Record"?  I'm new at arrays in Access and have been trying
to figure out how to make this work for several hours now - no luck.  Can
someone help?

I currently have two tables, one for Purchase Details and one for PO General
Purchase Details:
DATE     ITEM   QTY   PRICE  PO#
This is joined to the PO table:

This may seem like a simple query function to many of you. However, I have
yet to find the solution.
I am trying to convert these fields: startdate,enddate to an exact duration
such as:

I have a Invoice history table that appens my invoice current table. I want
to create a query that take the ship date and price from the current table.
There are over 30000 records in the current table. I only want the lates
price for each food number. Can anyone help?

I need to know how to create a cv on microsoft so i can then email it on to
potential employers

Hi
I need to sum a column using group by. the data type of this column is
date/time.
Iam storing time in this column as hh:mm.

I have a baseball statistics database. I want to be able to run a query w/ a
prompt that will allow the user to  look at the last 'X' games, with 'X'
being supplied by the user in form of a parameter prompt.  Here is the code I
am trying to use, but I continue to get syntax ...

I have several queries that ask for Between [BegDate] and [EndDate] via a
parameter value dialog box and I have other queries that contain hard coded
date values. But, what I need now is a query that prompts the user to enter a
single [ReportDate] value and then returns all items ...

I have following query which calculates total of quantity of all records
with same ID:
SELECT tblInventory.ID, Sum(tblInventory.Quantity) AS SumOfQuantity...
In anothet table I have a field [Required] which is related to ID.

I wonder if anyone can help me with this.
The scenario is that I have a pair of related tables. One contains
record labels, the other contains contact names at those labels. In
the contacts table there is a boolean field called blnLabelDefault

I have a table, tblNBAC of over 100,000 name.  I am looking to run a query
to do:
1) Count the total records in the table.
2) Divide the total record count by 20 for twenty people.

I've a table like this:
ID - PartNo
-------------
1        a

I have it down to display all cleaning jobs Due Today ex. Wed.  I have a drop
down list where the frequency is selected.  Mon,Wed, Fri - Tue, Thu -mon -
and any combinations of days for the week.  
However some of the jobs only need to be done once or twice a month.  not