Showing dates like in a Excel worksheet Nicola M 12/31/2008 12:53:01 AM Hi all! Access 2003. How can I show dates, or better, days in sequence ( 1,2,3,...,30,31,1,2,...,30,1,2,... grouping par 3 months) so to get a report like a tipical excel worksheet with days in cells Bn,Cn,Dn,... and data on rows A1,A2,A3 etc. Any table in my DB contains all these days but only short periods using the fields (date/time) From and To. Periods will be show like an X when the column match the relevant row. Sorry for my bad English. By the way I hope to have been clear. Thank you all in advance for tips, advices and suggestions. Have a wonderful and Happy new year! Nicola M

RE: Showing dates like in a Excel worksheet Duane Hookom 12/31/2008 4:23:00 AM If I understand correctly, you might want to check out this dynamic report solution http://www.tek-tips.com/faqs.cfm?fid=5466. -- Duane Hookom Microsoft Access MVP "Nicola M" wrote: [Quoted Text] > Hi all! Access 2003. > How can I show dates, or better, days in sequence ( > 1,2,3,...,30,31,1,2,...,30,1,2,... grouping par 3 months) so to get a report > like a tipical excel worksheet with days in cells Bn,Cn,Dn,... and data on > rows A1,A2,A3 etc. Any table in my DB contains all these days but only short > periods using the fields (date/time) From and To. Periods will be show like > an X when the column match the relevant row. > Sorry for my bad English. By the way I hope to have been clear. > > Thank you all in advance for tips, advices and suggestions. > > Have a wonderful and Happy new year! > > Nicola M