Formatting for a Weekly Report

I

iholder

How can I use the format function in a query to filter records for a weekly
report. Similar to the Month and Year format in the report wizard.
 
D

Duane Hookom

For those of us that don't use the report wizard, you might want to provide
us with your requirements.
 
I

iholder

A simple query to filter records on a weekly basis.
example below is for filtering records for a month

Date By Month: Format$(qryTelephoneCalls.Date,'mmmm yyyy')

Year([qryTelephoneCalls].[Date])*12+DatePart('ww',[qryTelephoneCalls].[Date])-1

How can I use these format for a week, if possible.
 
D

Duane Hookom

Try:
DateByWeek:Format(qryTelephoneCalls.Date,'ww')
This will group weeks from different years together.

--
Duane Hookom
MS Access MVP


iholder said:
A simple query to filter records on a weekly basis.
example below is for filtering records for a month

Date By Month: Format$(qryTelephoneCalls.Date,'mmmm yyyy')

Year([qryTelephoneCalls].[Date])*12+DatePart('ww',[qryTelephoneCalls].[Date])-1

How can I use these format for a week, if possible.

Duane Hookom said:
For those of us that don't use the report wizard, you might want to
provide
us with your requirements.
Click to expand...
Click to expand...
 
Top