i am having a problem creating a report from a data base i have.
originally the data was kept in an excel spreadsheet, but it is cumbersome to add new data to it, and to print it is not very efficient.
i have attached a couple of zip files,
1 the example roster is a s excel 2003 file
it contains the old format of a page organising the data the way i need to print a report out of access.
2 is the access database i created.
i cant get access to organise my data on a report to look like the spreadsheet does,and this is what i really need to do.
any help would be greatly appreciated.
i have created a report in the following zip file, the look of it on paper is what i am after, but i need to get columns for B and C and D on the same sheet.
How can i achieve this?
Is it possible to use 2 queries on the same report? and will that get me what i need?