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.
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.