Displaying the first and last record together

R

Ryan

I am using accessXP and what I am trying to do is the
following.

I have an orders table
I have a sub orders table

On the orders table I have a field for the work order
number.

On the sub orders table I have a field for a ID#(no the
key)

I am trying to print a report that will have a field on
it that will show the first(in numerical order) ID#-the
last ID#.

If this makes sense, I could use some help with this one.

Thanks

Ryan
 
Top