Hi All,

I'm not sure what the best way to go about this is, but I'll try to explain what I want it to do.

Hit a print report button and have it prompt me to enter a begin date for my contracts on record. (I know how to do that)

Hit a print report button (from the first time I hit it), and have it print EACH of my contracts (that match the date) out on a single page. My contracts are in letter format with fields planted around the text.

I also really dont want anything to open up, Id rather have the user just click the button, lets say they enter "01/07", and have it print out the "10" contracts/letters for that given month.

Any advice?

Thank you always,
Josh

use a group header and footer. one of the proerties is force new page - set this to after section.

I'm kind of confused. Is a group header the same as a report header/footer?

no a group header is just that. goto sorting and entere a vaue to sort on, look at the properties and you will find group header and group footer, switch them on here. to access the properties click the header/foorter bar.

Alright, I got that thanks.

One problem though, I'm surrounding the fields with text but i realized that some data in certain fields are going to be a differenent size. For example date.

This letter is to remind you on [Date] to.....

This letter is to remind you on May 31, 2007 to.....

This letter is to remind you on January, 31, 2007 to.....

So I'm going to have a spacing issue, is there any way to get around this?

I'm actually going to answer my own question. Since date is a field that changes size frequently, i just formatting my text withing the format field of the date field (surrounding my text by " ").

Hope this helps others in the furture.

Date is a reserved word in Access and shouldn't be used as a field name

Dont forget controls on reports have a shrink and grow property.