Monthly calendar report

[Sov]

Hello, right now I have a bunch of records of dates listed in one big row...ie
July 4
XXXXXX
July 5
XXXXX
July 6
XXXX
and so on..
I would like to know how to format the report into a calendar format so that
it looks like:
4 5 6 7
XXXX XXXX XXXX XXXX

any help would be appreciated

 

[Duane Hookom]

There are some sample calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. One of them is
formatted as per your needs.

 

[Sov]

I have been looking at that, I just don't get the "weekof + 1" thing.
I have a report that has all of the records listed. Do I create another
report with the "weekof +1" code. What do I reference that to?

 

[Duane Hookom]

Your main report is based on a query that has a single record for each Week.
The field named [WeekOf] contains the value of the starting date for each
week. All of the subreports in the main report are related to this field
value or the [WeekOf] + "x number of days".

 

[Sov]

So I would need to create another query that sorts all the days into weeks?

Your main report is based on a query that has a single record for each Week.
The field named [WeekOf] contains the value of the starting date for each
week. All of the subreports in the main report are related to this field
value or the [WeekOf] + "x number of days".

--
Duane Hookom
MS Access MVP

I have been looking at that, I just don't get the "weekof + 1" thing.
I have a report that has all of the records listed. Do I create another
report with the "weekof +1" code. What do I reference that to?

 

[Duane Hookom]

The calendar report does this. Take a look at its record source.

--
Duane Hookom
MS Access MVP

So I would need to create another query that sorts all the days into
weeks?

Your main report is based on a query that has a single record for each
Week.
The field named [WeekOf] contains the value of the starting date for each
week. All of the subreports in the main report are related to this field
value or the [WeekOf] + "x number of days".

--
Duane Hookom
MS Access MVP

I have been looking at that, I just don't get the "weekof + 1" thing.
I have a report that has all of the records listed. Do I create
another
report with the "weekof +1" code. What do I reference that to?

 

[Sov]

Thanks for you help Duane...
I just still don't get how to do this, I don't seem to be able to group
records into weeks

 

[Duane Hookom]

What are you attempting to use as the record source for your report?

 

[Access Resource]

Send me an email to (e-mail address removed).