I have never seen this behavior before.  Access continues to amaze me.
I just purchased a new laptop, installed Access 2003 SP2.  I am running
an update query on a mysql database via ODBC.
Let us say I am doing a single table update query, updating 1 single

There are 28 pages on deleting duplicate records in help. Can I use one query
to delete dupliucate records (based on two fields) but keep one of the
duplicates? Make it simple please.

How do I create a query that will:
Add a previous day gas total with todays totals. I need to start with the
total gas value on 10/31/2000, and have a running total.  I need to base the
running totals from each date.

I am trying to make calculations with time.
My table has 2 coluns with time as Intreger and no format, (ex. 1000378)
this must be as 10:00:378 (mm:ss:dscsms).
I need to add 2 fields, i have some exemples but i just can't get this

Send some suggestions ASAP.

Anyone do an org chart in Access?  I need an example.. kinda stuck on
how to go about it

This is the SQL script of an Access query I run.  Each record is being
duplicated in the result.
Can anyone see from this script where I am going wrong?
My thanks for any suggestions.

I have a database to manage inventory, invoices and receipts.
I have two tables for the receipts, Receipts and ReceiptsDetails.
The table Receipts has the fields ReceiptN, Date and Clients. The table
ReceiptsDetails has the fields ReceiptN, Invoice and Value.

For some reason for the last month or so, when I elect to compose a message,
I get a word form and there is no "Send e-mail" selection in the file
section.  I do not want Word, and I do not use Outlook Express.  Please tell
me someone: what to do?

Is it possible to retrieve a query result which multiply a field value of one
table with a cell value (not field) of another table? I tried and search a
lot but nothing shows me the way to accomplish the task. Any suggestions
would be appreciated!!

Table A
data= 20text
Table B
Key=4text

Sorry if this has been answered before, but I couldn't find it via a
search.....
I have  a macro with two append queries and a report.  I need the start and
end date paraters in all three, for selection in the appends and printed on

Can anyone please help me?  I need an update Query written and I don't know
how to do it.
Update Query needed...
I want to take 4 existing columns of data (names) in one table and append

I have a parameter query, "Between [Enter Start Date  (dd/mm/yy):] And
[Enter End Date (dd/mm/yy):]".  If I want to show all records, how can I
disable the 2nd input.
Thanks,

Is it possible to base an update query on the results of another query?
Not my goal in life to do this, but I'm having trouble getting the correct
results in my update query.
BR