Jim,
There are several ways you can do this. The easiest way is probably to create a query with some kind of definition. For example, you can do the following:
iif([NumofDays] < 30; 1;iif([NumofDays] between 31 and 45,2,iif([NumofDays] > 45,3)))
where [NumofDays] is either your calculated field.
Essentially you are saying that the following "date buckets" are formed:
records less than 30 days are coded as bucket 1
records between 31 and 45 are coded as bucket 2
records more than 45 date are coded as bucket 3
... and so on.
In terms of counting the number of records within these buckets, you could create another query that will count the number of "date buckets" you have defined in your query above.
Hope this helps.
Jose
luvmymelody <[EMAIL PROTECTED]> wrote:
luvmymelody <[EMAIL PROTECTED]> wrote:
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
SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
