I have a shipment file where I need to match 3 columns that are the same
(order #, ship date, and cosignee #).  Usually there are about 10 rows where
these columns match, I need to locate these and then sum up a fourth column
(weight) to make one shipment from the 10 fragments.

I have two linked tables in my db.  I need to pull all the values from
tableA and insert into tableB where tableA.id = tableB.id
Here's my SQL query, which isn't working:
INSERT INTO tblA

I have a query where I am trying to get the same date and time where the min
qty occured.  Example:
Table:
Date     Time     Qty

If I set relationships between my tables, my query does not read from the
tables. If I delete the relationships, my query starts to multiply the data
in the query.

How can you several text fields concateneren in access in 1 query to 1 text
field? Bijv. Text1 = 1111, Text2 = 2222, Text3 = 3333. the result must be:
"111122223333".

I have a table of Agents with ID_Agent as primary key and LastName as text
field, ex.
ID_Agent    LastName
1                BOBET

I'm trying to do the following. I use a query to calculate the difference
between two dates for a specific invoice. Then I want each customer to be
shown on one row where I "put" the sum of one or more invoices in different
intervalls i.e. due 1-10 days, 11-20 days etc based on ...

I have a sub form with a field called shop number, I have a query but would
like the query to (after clicking a button) use the shop number to populate
the query - i think command is something like Forms![FormName]![FieldName]
but this comes up and asks me for parameters - am I ...

I have a database which includes a table of carton descriptions. The table
has two columns - ID and Description (as below)
ID     Description
1      02*936 + 01*921 + 12*854

I wrote simple select query in a database I maintain this afternoon and
the query is returning multiple copies of the same record, 522 copies
to be exact. The query is written using three tables which are related
( I have used these relationships in other queries and they work fine) ...

I have a report (just a simple table) that I've created from a crosstab
query.  I've included all 'columns' in the report, but all the columns are
not always present in the query.  Now, when one of the columns is missing,
the report won't run because the report contains a field ...

I have two tables a main table and another we'll call Table 2.  I joined them
so it says "all records from main table and only records from Table 2 when
they are equal, and matched by ID.  There are no records yet in Table 2.  
When I make a query or form and go to add information ...

I have a field called Given Names and it includes both the first and the
middle name of a customer.  I would like to break the two names into
individual fields.  In other words I want to show just the first name in a
field and just the middle name in a second field.  How do I do ...

I am trying to do a select query on one table.
This table has many records with a DATE type field in each record.
I would like to select all records from the table with a given month and
year, the day is not important in this query.

I am trying to send out Quarterly statements based on the issue date of the
contract.  I just need to know how to update the Next Statement field with
date of the next statement.  Basically adding 3 months.
This is the code I am trying but am unable to get to work because I need ...