Help with Form Printing Formats.

[Phil]

Hi! I work in a large trucking company where I am trying to develop a simple
solution for printing dispatch sheets. These sheets have a few elements:
Trailer Location, Trailer %, Trailer #, Driver Name, Trailer Destination,
etc. These sheets are given to drivers to tell them which trailers they are
taking. My company uses a propritetary database, but allows me to export to
excel (and then access). I'm having a small problem with getting access to
print two trailer numbers with the same driver on the same form. Some
drivers are dispatched with two trailers and need to be on the same sheet. Is
there a way to allow me to have two trailer numbers assigned to one driver,
and then print all the sheets? Any help or direction would be awesome.

 

[Dale Fye]

Phil,

Try setting up a Group in your report, and group by the driver name, or
Driver ID.

Then, drag the driver data from the detail section of the report to the
group header.

Then, in the group footer properties, set the ForceNewPage property to
AfterSection. This should give you a new page for each driver.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Dale Fye]

Actually, Phil, my previous comments assumed that you were working with a
report, not a form.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.