>>In the browse window does the cursor look OK? If yes, then something is wrong in the report itself.
Did you verify the cursor? Do you have the duplicates in the cursor?
If not, add
select * from curResult into table myDataTable.
Close the form.
Open the myDataTable. Examine it.
Now run the report against this table. If the report shows incorrect information, verify, that the report doesn't use private DS. Also verify the report itself, may be you setup it wrongly.
>Still the report prints duplicate records if I leave a combobox blank which is what the customer is looking for is to be able to pull up reports by user only or be able to pull up strain only (All based on the date function)
>
>I hope this time I was clear. It's easy to get lost when you are already halfway there.
>
>Thanks,
>
>Fred W.
If it's not broken, fix it until it is.
My Blog