Duplicate Data on Queries

[spyldbrat]

Hi,

When run my query, the results have many lines of the same exact date (dup data). I am not sure why this happens, but I am now in position that the query is not capturing all the data upon exporting to excel because the duplicate data is creating more rows than the number of rows in excel.

I know there is a way in design view to stop this from happening upon running the query, I just don't know what it is I need to do. Please help.

Thanks.

[ranman256]

you can get duplicates depending on the join of 2 tables.

eliminate the dupes by setting the query property: UNIQUE VALUES = TRUE

[spyldbrat]

Where do I find the query properties?

[spyldbrat]

I am not sure how I got there, but I found it!!! HA!!! I think it worked. Thanks.

[JoeM]

When run my query, the results have many lines of the same exact date (dup data). I am not sure why this happens

That usually indicates that you have a one-to-many or many-to-many join, which may just be the nature of the beast, but often times is an indication that there may be a problem with how you are joining your two tables.

For example, if you have two tables that among other things, have a First Name and Last Name field, but if you only join the table based on the Last Name, you may get duplicates because the Last Name is not a unique field. So you would have to include First Name as another join field in your query to rectify that.