Calendar Report, how to create??? 2

[murf]

I need to print a report that looks like a monthly calendar that can be printed for each customer and has data for the customer on specific days of the month that will need to print. Does anyone know how I can accomplish this task?

 

[CCS8DENI]

Create a simple query and insert the following expressions. These all rely in the date feild being called Date<br><br>Month: DatePart(&quot;m&quot;,[Date])<br><br>monthname: IIf([Month]=1,&quot;January&quot;,IIf([Month]=2,&quot;February&quot;,IIf([Month]=3,&quot;March&quot;,IIf([Month]=4,&quot;April&quot;,IIf([Month]=5,&quot;May&quot;,IIf([Month]=6,&quot;June&quot;,IIf([Month]=7,&quot;July&quot;,IIf([Month]=8,&quot;August&quot;,IIf([Month]=9,&quot;September&quot;,IIf([Month]=10,&quot;October&quot;,IIf([Month]=11,&quot;November&quot;,IIf([Month]=12,&quot;December&quot;,&quot; &quot)))))))))))<br><br>Day: DatePart(&quot;w&quot;,[Date])<br><br>Week: IIf([Day]=1,&quot;Sunday&quot;,IIf([Day]=2,&quot;Monday&quot;,IIf([Day]=3,&quot;Tuesday&quot;,IIf([Day]=4,&quot;Wednesday&quot;,IIf([Day]=5,&quot;Thursday&quot;,IIf([Day]=6,&quot;Friday&quot;,IIf([Day]=7,&quot;Saturday&quot;,&quot; &quot))))))<br><br>Then use the sorting and grouping menu to organise the calendar. I could send a sample report. Group and create headers for Month then include the week field, date and any other content in the detail area

 

[CCS8DENI]

Ooops!<br><br>Andrew<br><A HREF="mailto:andrew@mcmillan.net">andrew@mcmillan.net</A>