I have data in a table as follows:
Company     Location        Number
Comp A       CA                3
Comp A       WA               3

I have looked in the posts for this problem, but I guess I am not asking the
right questions.
I use Access 2003.
I have the typical setup for products …combo box A to select a category for

Hello i have a table

Can someone explain the grid on the update query.
Does it go like this..
1. field: what field you want updated
2. Table: The table from #1 (above) field

I have a query containing a field POID. I want to set the criteria for this
field to a value obtained from one of two forms. This is what I've set as
the criteria:
[Forms]![frmChoosePONOFilt].[cboPONO] Or [Forms]![frmOrderFilt].[txtPOID]

I need to delete records from several tables but I get an error about
selecting the table where to delete these records?
This is an example of one of the tables I need to delete these records from.
I first did a select query (OrderID's To Delete)

I am trying to combine an Access program that we have at different sites
into a single one. I have been able to accomplish almost all of it but have
hit a snag when when running the history look up form. I have tables labeld
"History_Table_Birdsall" or "HIstory_Table_Cascade" etc ...

I stole the "mangled" from another post.   It seems appropriate.
I went into the SQL on one of my queries and created my own subquery as
follows
LEFT JOIN (Select * From tblSubs_tags Where Code = "NP") AS SubsTags ON

I have a spreadsheet which contains a parent name and 3 children inames n one
row. I want to import the data into access, I have a parent table and a child
table, both of these are linked with parent id as a foreign key in child
table.

I found the following article and sample DB.
http://office.microsoft.com/en-au/assistance/HA011102181033.aspx
After importing the module, everything works great.  However instead of just
House:Minutes, I would like to edit the module below to display

I am trying to create an autonumber field within a query, but I would like to
autonumber by groups. I have two fields in the query, but would like the
third to be the autonumber grouped on the values in the first field. My data
would look something like this if successfull:

I am new to access.
My Data looks like columns a,b,c,d:
Id    Date    Time    Code    Difference
1    20060428    93155    53   

I thought I had solved this problem, but I have discovered I haven't.  I
have a query where I want a prompt for the user to enter a date and have only
the records returned from the date entered and the previous 30 days.  I had
entered the following in the crtieria field:  ...

i am creating a database (in access 2000) for mailouts among other things. i
found a tutorial in the knowledge base to allow 2 addressees at the same
address using 3 queries. one uses 'first' function on names, one uses 'last'
and the other links the two queries to give only 1 ...

I have two tables exp_recs and inc_recs both with the following fields :-
ID - Primary key
ac_gross
ac_date