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 ------------------------ 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/
