Report by week 1

[ProtegeV2]

Hi,

Is there an easy way to run a report by week (7-days)in calendar format? I want to display the weekday with the corresponding information i.e., [event name] below it. In my SQL below, how can you list "WhatDay" for each weekday for the month/year requested with the event information below it - so it would be a four page weekly report.

SELECT [Corporate Contributions].[Event Date], [Corporate Contributions].Eventtime, [Corporate Contributions].Organization, [Corporate Contributions].[Event Name], [Corporate Contributions].PLead, [Corporate Contributions].ELead, [Corporate Contributions].Donations, [Corporate Contributions].[Community Location], DatePart("m",[event date]) & "/" & DatePart("yyyy",[event date]) AS WhatMonth, DatePart("w",[event date]) AS WhatDay
FROM [Corporate Contributions]
WHERE (((DatePart("m",[event date]) & "/" & DatePart("yyyy",[event date]))=[enter m/yyyy]))
ORDER BY [Corporate Contributions].Organization, DatePart("m",[event date]) & "/" & DatePart("yyyy",[event date]);

Let me know if you need more information!
Thanks.

 

[dhookom]

I'm not exactly sure what you are asking for but there are some sample calendar reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

There are some crosstab style reports that might also be handy.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[ProtegeV2]

Thank you, I will give it a try.