I am posting my sql for a query I am working on. I have changed the dates to
the week number it is in the year. Now I wan to have the week numbe into the
first date in that week.
I want to do this because when I put this into a cross tab query Week one is

I'm getting the error message "Could not delete from specified tables."
Here's the SQL:
DELETE wkReport.* FROM wkReport INNER JOIN QryA ON wkReport.SSN = QryA.SSN
WHERE wkReport.SSN Is Not Null;

How would I build a query that would sum up the total per itemid for 2 table
and then return the substraction value.  Let me explain
I have table1 with 2 fields (id and qty) and table2 with 2 fields (id and qty)
I need to perform the summation per id of each and then return the ...

BACKGROUND
I conducted a project that awarded shipments to truckload carriers.  I
need to track and compare these three things (monthly):
- the awarded carriers and their awarded percentages

I am trying to create a public function in a query
I have a table that lists all of the city and zips within district (cityzip)
EX: La Crosse 54601
In function I am passing city state and zip returning InDistrict,

I have a table with to key fields: Hours Worked and Revenue.  I would like to
build a cross tab query that uses each as that value with month as the column
header.  How do I put two values into a cross tab query.  I can't make
revenue a calculated field because sometimes revenue ...

Access 2000 (Yes, I know.  Old.)
I am designing a database to help me manage a research study.  Subjects will
be baselined, that date will be entered into Access, and the program will
generate a Follow-Up Interview date for 180 days after Baseline.  Our

I'm trying to create a query that generates some random fields.
Such as:
Select recordid, name, rnd(0) as field1, rnd(0) as field2, [field1] +
[field2] as sumof;

I have a table, a query of the table, a main purchase order form and subform
with a record source of the query and a report utilizing another query as the
record source.  
Table: Purchase Order Table

Having problems with multiple records being returned as I attempt to build
this query.
Here are my 3 tables with key fields:
(leading underscores added for viewing)

When I try to compact a our application database I get an error
message as
follows: "Record(s) can't be read; no read permission on
'<<filepath\filename.mdb>>'

Here is the query.
SELECT Nz(Count(a.com_num),0) AS Total, a.com_type
FROM a
WHERE (((a.date) Between forms![date range]![Start Date] And forms![Date

I have been trying to add multiple fields together to come up with a result
for one field.
It seems to work with two fields, but when I add the third field (of 6 or
seven), It doesn't.  Why?

Can anyone help with this please.
I have two lists, LIST1 and LIST2. They are in separate tables also called
LIST1 and LIST2 and each table has a unique reference text field called REF.
The lists are quite lengthy and to do this manually would be involved!

I have A query that has Calculation Table1 – Table2 = Table3
when I run the query a box opens saying Enter Parameter Value   (named
Table1) I click ok then  a box opens saying Enter Parameter  Value   (named  
Table2)   I click ok