billkond, i had recently upload one file. please get it for your solution.
hope after getting this file u will get solution. Thanks brij here. ----- Original Message ----- From: "billkond" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Thursday, November 24, 2005 11:50 PM Subject: [AccessDevelopers] date periods > Dear friends, > I need your help on this. > I have a table (lets say Paymentstable)with 5 fields > > 1) PaymentsID (data type : autonumber) > 2) CustomerID (data type : number) > 3) DueDate (data type : December 05,January 06,February 06, March > 06,... etc) > 4) Paid (data type: Yes/No) > 5) Amount (data type : number) > > I want a query at which i'll be able to define (each time) a specific > period of Duedate (for example from December 05 to April 06 or from > January 06 to May 06 , e.t.c.) and gives me a) which CustomerIDs the > Paid field=Yes and b) the sum of the Amount field for each CustomerID. > > Thanks in advance > Bill > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
