Delete Queries Won't Work!!!

[Only1Abhi]

Hi ppl.
Simple Problem.
I have an archive system in my DB.
However, the Delete query is NOT working and it shows EXTRA fields in the "Datasheet View".

Where have these extra fields come from?
How can I get rid of these?
How can I get the Delete queries to work properly?

There is also a problem on the append queries that says:
"Microsoft Access can't append all the records in the query".

Many thanks to every1 in advance.
Best Regards,
Abhi
)

Here is a link to download my DB...

http://www.access-programmers.co.uk...531b699a11661bb1046f9609b9f733c&postid=160352

 

[Steve101]

I had a quick look at your database. If you change your qryOldTransactions query so that it is not a Total query, and set the Unique Values property to Yes, and untick the 'Show' for the DateOfTransaction value, you should find that the DeleteQuery works ... it doesnt like being 'mixed' with a Total query.

The SQL for the qryOldTransactions when you've done the above should look something like this:

SELECT DISTINCT tblTransaction.CustomerID
FROM tblCustomer
INNER JOIN tblTransaction
ON tblCustomer.CustomerID = tblTransaction.CustomerID
WHERE tblTransaction.DateOfTransaction <Date()-90;

Hope this helps,


Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[Only1Abhi]

Thanks man... problem solved...

Best Regards,
Abhi