I need to write a report in which one part shows a count of how many
total records fall within the working days (Monday - Friday) inside of a
(prompted) given date range, in a particular geographical region.
I have written a query which prompts the user for the start and end
dates. It also filters for entries which pertain to the particular
geographical region.
I'm not sure where to go from here.
How do I filter the results to show only the records within the prompted
date range which fall within the Work Week (ie: Monday - Friday)? (
ie: I need to somehow filter out Saturday and Sunday days/dates within
the prompted date range)
Once I have the query filtered to show only records which fall within
the required date range, region, and only within the (Mon-Fri) Work
Week, I then need a simple count of how many records there are. How do
I achieve this result?
Can anyone help me with suggested coding, and structure in the query
grid so as to accomplish this result?
BlackFireNova
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!