Week format for text box

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top