How to query database with multiple queries

[Cady Steldyn]

I have the following fieldname in an Access_Table:

Field 1 = Cust_ID (Primary key)
Field 2 = Date
Field 3 = Description
Field 4 = Inv_No
Field 5 = Amount

My SQL Input syntax are:

"Select distinct Cust_ID,Date,Description,Inv_No,Amount from
Access_Table WHERE Date <Now()-30 And Date >Now()-60 AND Date =
Main.Date"

It failed to generate the result I want,anyway

My "Required" Output is:

Cust_ID Date Description Inv_No >30DYS >60DYS
8000 21/05/2004 PC RAM 200
8000 26/06/2004 Modem 180
---------------------------------------------------------------
Total: 180 200
---------------------------------------------------------------

8001 22/04/2004 Cable 50
8001 23/05/2004 HD 210
---------------------------------------------------------------
Total: 260
---------------------------------------------------------------
Grand Total: 180 460
can anyone help? Thanks
From:Cady Steldyn

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Bell]

Hi

You seem to have posted 3 very similar requests. Please see reply to
"SQL-Query Access by Date"

John

"Cady Steldyn" <dc*******@yahoo.ca> wrote in message
news:41**********************@news.newsgroups.ws.. .

I have the following fieldname in an Access_Table:

Field 1 = Cust_ID (Primary key)
Field 2 = Date
Field 3 = Description
Field 4 = Inv_No
Field 5 = Amount

My SQL Input syntax are:

"Select distinct Cust_ID,Date,Description,Inv_No,Amount from
Access_Table WHERE Date <Now()-30 And Date >Now()-60 AND Date =
Main.Date"

It failed to generate the result I want,anyway

My "Required" Output is:

Cust_ID Date Description Inv_No >30DYS >60DYS
8000 21/05/2004 PC RAM 200
8000 26/06/2004 Modem 180
---------------------------------------------------------------
Total: 180 200
---------------------------------------------------------------

8001 22/04/2004 Cable 50
8001 23/05/2004 HD 210
---------------------------------------------------------------
Total: 260
---------------------------------------------------------------
Grand Total: 180 460
can anyone help? Thanks
From:Cady Steldyn

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!