Blank document when previewing my reports

[Sheppyshep]

I am working with a hospital database and am trying to put together a report that runs statistics on the various demographics of the patients that come through. As such I have created multiple queries counting how many of X patients have been seen. I have then combined all of these queries into one and used it as the source for a report. I haven't used any expressions in the report only drag and drop from the source list. However, when I attempt to preview the reports (Now 3 of them because I also don't know how to subreport to extend past the height of 22"), it brings up an infinite number of blank pages. I'm self taught and have only been working with access for the past 8 weeks ~ 64 total hours. Please help!

[NeoPa]

This all really depends on what's set up in the report and, possibly, the underlying query. A frequent report problem with blank pages is that the design is expected to fit in a single page of A4, but due to extremely small levels of overshoot, you are left with many pages of seemingly blank info. This would typically come at the end though rather than the start.

You will need to tell us more if we're to be more help I'm afraid.

[Sheppyshep]

This all really depends on what's set up in the report and, possibly, the underlying query. A frequent report problem with blank pages is that the design is expected to fit in a single page of A4, but due to extremely small levels of overshoot, you are left with many pages of seemingly blank info. This would typically come at the end though rather than the start.

You will need to tell us more if we're to be more help I'm afraid.

Sure, I'd love to tell you more. Though I must say I'm not really sure what will be most helpful toward you helping me. So I'll just start. I've been working in Access 2002 but also 2003 (Depends on which computer I'm at). Currently I'm on 2002. My OS is Windows XP. My database is full of patient information. I'm running statistics on race, age, sex, cause of injury, etc. There are multiple tables which house these fields that I've now joined in queries and then queried the queries to "count number of X in Y." An example

Spine: DCount("[ICD Body Part]","Demo_OrthoDx","[ICD Body Part]='Spine'")

counts the number of spinal injuries out of all of the orthopaedic diagnoses. You can imagine that there are many things you could count to get the statistics you would need. As such, I have more of these counts than can even fit into a single query. I've split them into separate queries and used the separate queries as the source data for multiple reports. In design view I have been dragging data from the field list and dropping it onto the report. I format it how I like then copy it, and paste it again where I then manually change the data it is calling from say spine to toes. When I attempt to preview the report..Blank.

[NeoPa]

Do you have a Record Source for your report? If so, what is it?