Duplicate

H

HelpMe!

want to run a query that returns only records
where [onprobe] = no
[lastreport] is null or not between 9/1/08 and 8/31/09

it is returning duplicate records?? how do i make it not
 
P

Piet Linden

want to run a query that returns only records
where [onprobe] = no
[lastreport] is null or not between 9/1/08 and 8/31/09

it is returning duplicate records?? how do i make it not
Click to expand...

you must have a join in there, so that you're returning all the
records from the many side of the join and then duplicating the items
from the one side that have many child records. You would have to
remove the fields from the child table from the query (uncheck so they
don't show), and then maybe use a DISTINCT
 
K

KARL DEWEY

Post the SQL of your query. Open in design view, click VIEW - SQL View,
highlight all, copy, and paste in a post.
 
Top