Hi
You seem to have posted 3 very similar requests. Please see reply to
"SQL-Query Access by Date"
John
"Cady Steldyn" <dcartford@yahoo.ca> wrote in message
news:4143cec5$0$26127$c397aba@news.newsgroups.ws.. .[color=blue]
>
> 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![/color]
