Report to one page

[idcowboy]

I am tiring to set up a report so when I print it no matter if I have 1 record or 15 it will come up on one page. let me explain. I am tiring to do a price bid database and when I create a price bid I need to be able to print it out, however if I do more than one price bid it doesn’t just use one page it may put 2 on a page and so on. any ideas?

 

[dhookom]

I don't know if anyone else can understand this but I am having trouble. Can 15 records fit on a page? What would place records on different pages?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[idcowboy]

I am doing a price bid and the reports are categorized by company, the company I am doing a price bid for and when I have a price bid for more that one company it wants to add on the other company right after the first and doesn’t always go to the next page no matter how hard i try to format it.

 

[dhookom]

Could you please be more specific regarding your table structure, some sample records, and how you would like your report to display.

In reports, we use the term "Grouping". Is this what you mean by "categorizing"?

Please check the faq link in my signature to find out how to ask a good question.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[idcowboy]

Yes I do mean grouping sorry my terminology is very poor to say the least.
here is the structure of my 2 tables
Table: pbid
pb id auto number
pb detail number
pb date date/time
Company text
print yes/no
transfer yes/no
Table: pbdetail
autonumber autonumber
pb id number
item name text
description memo
cost number
quote number
supplier text
notes memo

I have is set up in a form one to many a single company can have many items
Here is an example:

SE/Z Construction Friday, March 05, 2004
Neil Schaffer
325 S. Woodruff
Idaho Falls Idaho 83403-1469
(208) 528-9449
Here is the price bid on the office supplies that you requested.
10/100 Single Port Print Server $75.00
A-1 Automatic Transmission Thursday, March 04, 2004
Mitch
540 N Utah Ave
Idaho Falls ID 83402
(208) 523-2431
Here is the price bid on the office supplies that you requested.
27X $49.00
92295A $69.00
Thank you for taking the time to look over this price list. If you have
any questions, please feel free to call.
1
Sincerely,
Brandon

it shows all of this on one page I want to be able to separate the company's, A-1 Automatic Transmission and SE/Z Construction.

Thanks if you have any other questions please let me know thanks again.

 

[dhookom]

There is a page break control in the tool box that you can insert at the bottom of a section. There are also properties of section that allow you to specify breaking before or after the section.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[idcowboy]

thanks I will look into that

 

[idcowboy]

I gave it a try but I still can't seem to put it in the correct place if I put it in the detail frame then it only prints one of 2 records if I put it in the page footer it does not work either any other ideas?

 

[idcowboy]

I figured it out w/ grouping thanks