Jim, I uploaded an example (Ac2k Buckets.mdb). Let me know if this does what you need, or if you have any questions about how to modify it.
Far Farley www.TheAccessWizard.com -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of luvmymelody Sent: Monday, November 28, 2005 7:55 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Query of sums for periods of <30 days, and between 31 and 45 days Hello everyone, I have this database with about 121,000 records that is downloaded from SAP every week. I need to create a query that will list the records <30 days, also between 31 and 45 days, all the way up to 91+. We call them buckets. They essentially are date buckets. I have tried to add to the qbe to get the <30 > 30 to 45 and so on. I have been unsuccessful as of two days. My boss wants to go live with the database Wednesday at noon. Please help. If I could also find away to get another query to just be the sum of of each respective buckets of dates would be great. Thanks in Advance Jim Wagner 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/
