I've written a querie to look at 3 tables I want it to pull data by the dates I enter. My problem is it will pull the data but if their is only 3 records that match my querie it fills the whole sheet with duplicates. How can I fix this?
Novice
Windows XP 
Access 2003
I've written a querie to look at 3 tables I want it to pull data by the dates I enter. My problem is it will pull the data but if their is only 3 records that match my querie it fills the whole sheet with duplicates. How can I fix this?
Competent Performer
Windows XP Access 2002 (version 10.0)
Use "select distinct" instead of "select".
Administrator
Windows 10 Access 2013 32bit
TimT,
I believe you will find it is your joins that are causing the duplicates, or maybe the lack of them.
Posting Permissions
Reply With Quote