I have a report (image below) that is printed for employees to have signed after each leg of a trip. A job can have two legs (two pages to be signed) or a job can be a one-way trip (one page to sign). How can I make it if a job has one leg one page prints (not two), two legs two signature pages… currently I’m using a page break and it defaults to two pages always. Unfortunately, the table is based on a spread sheet we receive nightly and imported into the DB with all legs in one record.
tblJobs
ID
CustomerName
DOB
Homephone…
jobnumberA
jobnumberB
PickupaddressA
PickupaddressB
DestinationAddressA
DestinationAddressB
…
Report
page one= A info
page two= B info (again record doesn’t always have B info)
tblJobs
ID
CustomerName
DOB
Homephone…
jobnumberA
jobnumberB
PickupaddressA
PickupaddressB
DestinationAddressA
DestinationAddressB
…
Report
page one= A info
page two= B info (again record doesn’t always have B info)