Monthly calendar report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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".
 
So I would need to create another query that sorts all the days into weeks?


Duane Hookom said:
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


Sov said:
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?
Click to expand...
Click to expand...
 
The calendar report does this. Take a look at its record source.

--
Duane Hookom
MS Access MVP


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


Duane Hookom said:
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


Sov said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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
 
Back
Top