Duplicate

  • Thread starter Thread starter HelpMe!
  • Start date Start date
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
 
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
 
Post the SQL of your query. Open in design view, click VIEW - SQL View,
highlight all, copy, and paste in a post.
 
Back
Top