Min record number and Max record number

D

Duane

Hello,

I have a report which summarizes the jobs between a certain time frame. For
instance, there is a field called Shipper#. This Shipper# might contain
several jobs, therefore the query counts the jobs and sums the sales. There
would be several Shipper# during the time frame. I would like the report to
show the Min Shipper# and the Max Shipper# for each page.

Is there a way to use two text boxes and show the Minimum Shipper# and the
Maximum Shipper# on each page, in the Page Header?

Example:
# From: 01459
# To: 01494

Then on the next page:
# From: 01495
# To: 01530

Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top