M
MJC
Hello,
I have set up a query to count the totals our sales reps
give out on a daily basis and I want to merge it into a
report. I want the week to show the dates for Monday -
Friday (or Sunday-Saturday).
I want the report to look like this:
July 21 - July 25
7/22/03 4
July 28 - August 1
7/29/03 9
How do I format a controlled field with that week
information without adding a field to the table/query? I
can get the week # in there, but I want more of a start
date to end date for the week.
Thanks.
I have set up a query to count the totals our sales reps
give out on a daily basis and I want to merge it into a
report. I want the week to show the dates for Monday -
Friday (or Sunday-Saturday).
I want the report to look like this:
July 21 - July 25
7/22/03 4
July 28 - August 1
7/29/03 9
How do I format a controlled field with that week
information without adding a field to the table/query? I
can get the week # in there, but I want more of a start
date to end date for the week.
Thanks.