Can't Get Report to One Page

[buee04]

Hi,

How come my report keeps on ending up to be 3 or 4 pages? Everything can fit into one page but then my report details section is repeated for 2 or 3 pages and then ends with my report footer. What do I need to do to make sure it's only 1 page?

Thanks in advance!

 

[mikey69]

Sounds like a problem with the underlying query. do you have a one to many relationship there? Would need more detail to make better comment.

 

[buee04]

Hi!

I'm sorry, I'm still new to Access. What do you mean by one to many relationship for my query? I thought relationships were only for tables, so I don't know if my query is one to many.

Hmm, more detail... I'll try. My report, rptResult, displays details for one record. Its recordsource is qrySearching. I have 3 forms leading up to the report. One is the search form, frmSearch, that allows the user to search for a record. Then the records are returned in the frmSearchResults. You pick the record you want to display a report for and then that takes you to another form, frmReportSelect. This form allows the user to choose different fields to be displayed on the report, along with some default ones.

I don't really know what detail you need but I'm just telling you what I can remember from the top of my head. I'd probably tell you more if I wasn't locked out of my db right now (another thread)

My report has only a report header, detail section, and a report footer. I took out the page header/footer cuz I don't really know what any of them is. I have the default fields and 2 pics in my report header, more fields that are selected by the user (if the user doesn't select any fields, then it should just display the header and footer), and the footer has one pic. What is repeated for 3-4 pages is the report header and the detail section, but without any pics. Then it is ended by the report footer.

Hope this is what you need.

THANKS VERY MUCH!

 

[mikey69]

Sorry - you can relate tables either in the relationship menu or in the query grid. If your query, qrySearching, is getting data from more than one table and there is a one to many relationship between the tables, this can give you multiple output. I'm not able to figure out from your description how your database works, so don't think i'll be much more help. sorry about this

 

[buee04]

That's cool mikey, I was able to get it to work. Im not really sure what happened but when I got the linking images part on the report, it managed to stay on one page. Weird.

But in any case, thank you!