I have a report in an Access ASP that runs a report. This report has run for some time and has the following problem:

The Report displays one record TWICE. When I run the stored procedure on the MS SQL back end, that particular record shows only once...
If the record showed twice in the SP execution... I could eventually figure it out... but this?

There are no footings or totalling sections.
Any ideas would be greatly appreciated.

Paul

Paul

__________________
Paul

Post you asp code

urt

Post your asp code

urt

Sorry... my fault. I meant an Access project. An ADP file.

Paul

It could be that the query behind the report is not set to give you distinct records. Check your SQL and make sure that it starts with SELECT DISTINCT; or if it's a query, make sure you set the query properties to "Unique Records: Yes".

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division