Hello,
I have a question about creating a log sheet. It looks like an Excel spreadsheet. Currently entries are handwritten n this sheet going across, then the entries continue on the next row once the entries reach the end of the page to the right. Now thing is, the dates are not consistent. Entries can be at any time (a week, 6 months, etc.) The user will enter the date in the grids. I just need the entries to go across the page then continue below once it reaches the end on the right. Here is an example;
10002 |4/15/10 | 5/15/10| .........................|12/15/10
|1/17/11| etc.
10003 11/19/2009 5/4/10 .......................
They will have gridlines. I thought Crosstab reports would be the answer but it does not do what I need it to do.
I have the queries set up. I just need to reports appearance to look like an Excel type logbook.
I have a question about creating a log sheet. It looks like an Excel spreadsheet. Currently entries are handwritten n this sheet going across, then the entries continue on the next row once the entries reach the end of the page to the right. Now thing is, the dates are not consistent. Entries can be at any time (a week, 6 months, etc.) The user will enter the date in the grids. I just need the entries to go across the page then continue below once it reaches the end on the right. Here is an example;
10002 |4/15/10 | 5/15/10| .........................|12/15/10
|1/17/11| etc.
10003 11/19/2009 5/4/10 .......................
They will have gridlines. I thought Crosstab reports would be the answer but it does not do what I need it to do.
I have the queries set up. I just need to reports appearance to look like an Excel type logbook.