How to create report

[jags281173]

I am a novice to the Access. Can anyone help generate a simple report from a data of residential units. If ready to help, pl send email so that I can sent database.

[June7]

If the report is really simple, Access Help has guidelines on how to build reports. Also many tutorials on web. An introductory book on Access will have instructions.

You can attach file to post.

[jags281173]

Pl find attached the db. First two parts of the Report called 'Ledger' ( attached as doc file) to be picked up from the table 'Master Data' and last part to be picked uo from the table 'Lfee'. Report should show separate sheet for each quarter

[June7]

I am not going to build for you. Would take too much time to analyze the data relationships and figure out queries. However, after a quick look I will say that it doesn't look easy. Probably needs to be a report/subreport. The top part will probably require a UNION query to rearrange the data then a crosstab of that query. The bottom part appears will need join of the tables. Unfortunately, the data doesn't make sense. The tables have Quarter_No and Qtr_No fields that I thought would be link fields but they don't have common values. Make effort to build report and if encounter specific issue, post for analysis.