I am using Access2000 as the database, but the app will be run on machines without Access, so it has to stand alone (using the access runtime only).

Currently, I am using the DataReport tool in VB (although in the next release I plan on switching to Crystal, but for now I have to go with this due to time - I have to learn Crystal first! and I am over a month beyond the orig deadline for delivery, so I can't afford any major changes.)

I did get another idea, but again I am not sure how to go about the execution of it... what if I create the first rec set and put those results in a NEW TABLE? then query the new table to pull out the correct record? How easy is it to create AND destroy tables as I don't need it after the report has been printed and closed?

I have to go off line for a couple hrs, but will be back later (3+ hrs from now).

APPRECIATE any and ALL help on this!!!