Access Workday Query
Posted on 2008-10-09
I have a table that contains a CreationDate. This is the date the item was created. I currently produce metrics on how many items are aging 0-2, 3-13, and 14+ days. I do this in seperate queries using statements like "Between Date()-2 and Date-14". I then do a seperate query for each which feeds me the totals. This has been working extremely well.... however, now I need the same queries to return only the workday (i.e. records created Monday - Friday) records. I am not worried about holidays, just that the records are M-F. For instance if today is Monday, the 0-2 day query would need to return all the records that were created on Thursday and Friday versus Saturday and Sunday.
I've been searching high and low and there are a lot of Modules created that count the number of workdays, but none that seem to return all records between the days. I am sure the code could be modified, but know nothing about VBA coding. Need this pretty quickly so any and all help would be greatly appreciated.