That's what I need to end up using that field on yes.
Thank you,Mike Klausing
I want to take this "1" and be able to display it on a form separate from all of the other information in this table.
Because if I move the entire table over to a printable document I have to box it in like the number" 2" below. Where the rest of my document has blanks running along the left hand column. I want to single out the table into multiple pieces of information so I can place them where I want, rather than only being able to control the table as a whole.
Mark,I think that will work good in my situation where I create summary fields of the minimum record ID #. How do I create the 2nd minimum? As an actual formula field in my table or in the table to table relationship summary area?
Nevermind Mark I found it. I created a summary field and added the criteria at the bottom where it had to be > my first minimum record ID.