View Full Version : My Report is multiple pages when I want only one


nhughes13
08-03-2000, 11:57 AM
I have am running 8 append queries that come from different tables. When the queries are run, the results are sent to a table. I have a report that pulls the information from that table and puts it into a report. My problem is this: When the queries are run and the info is stored in my table, the table has a stair stepping look to it. When the report is made from the table, the first blank is filled in on the first page, then the second blank on the second page and so on till page 34. I need to know how to either make my table have one row of information in it or how to make my report take multiple rows of information and make a single page report out of it?

Travis
08-03-2000, 09:48 PM
It sounds like right now that your 8 Append Queries all hold a piece of a single record. Use an Append Query for the First Entry and then Update Queries for the last 7. This will place them all in the same record.