Any help would be greatly appreciated, as this has proven to be very
complicated and I have been trying to get this for more than 2 days
now.  I am trying to define the monthly average set-out rate per route
for households that recycle, based on the route logs provided by the

I wish to do a math calc query so one field is subtracted from another to
give an answer in a new field along the lines of....
Tare In - Tare Out = Nett
I tried along the lines of...

This is a rather weird question, but I thought Access users muct have a bit
more experience in SQL statements.
I connect to an excel workbook using OLEDB and use a simple select statement
to get all rows in a sheet. But sometimes I get an error!!

I have a Query which(correctly) requires a parameter when run. If I am
using Access, I get a GUI dialog prompting for input. However, I need
to use this query through an ODBC connection from another program? Is
there a syntax I can use to pass additional named parameters over ODBC?

Trying to create a query where I need move data from one textfield in one
table to another textfield in another table.
The from table is called TblPath and contains one record only, and it has a
field called PicturePath1.

I have a Make Table Query which makes a table called "Companies."  The source
for the query is a table named "Outlook."  I wish to make a one of the fields
which is created in table "Companies" a Primary Key Index.  How can I do this?

I have a table and three of the fields are AmountBought, AmountSold and
AmountInStock. In a query how do I subtract AmountSold from AmountBought to
come up with AmountInStock.
Thanks for any help

In VB code, I use .Column(number) but how do I do it in SQL, it rejects that
syntax.

I am trying to update a field in one table with the contents of a field in
another table.
My tables are:
Product

Okay, I give up.
Access is the only DB that I can't seem to giev me a Distinctive Count of
unique Sales Numbers.
I have a Sales DB that writes to an Inventory table. Now, I have a query &

I have a table used in scheduling classes, set up like this:
ClassID       CLass       Day 1   Time1      Day2  Time2
34566       Biology      MTRF  11:30
34567       Chemistry    MT      11:30      RF       11:15

Running an update query in Access 2003 on linked MySQL tables via ODBC,
running MySQL on a Windows 2003 Server. The query fails, returning the
message that the query didn't update 103 records due to lock violations.
This same query runs just fine when run against the same dataset ...

I have a rather small table( 2204 records ) at the moment. We need to
generate a report that will spit out some prices that are totals based
on these records. So far so good and this query works too. Most of the
time....

In my table the field name is 'NameOfFile' . Basically data looks like this,
'C:\Folder\Data\5-22-06 this month.txt'.
I need get some portion of this data, only date, for exmple '5-22-06'.
This is only removes everything after date,

I have a historical event list of different statuses for an individual
record, where events follow one after other and recorded.
The result of the crosstab query looks like this:
                          read      assigned      completed