Allowing Duplicate Data in a Query

SimplyDemented

Registered User.
Local time
Today, 11:20
Joined
Jun 7, 2007
Messages
15
I have a database that allows multiple entrys of the same information. I also have a report based on a query that pulls out said data.

I just need my query to pull out every record regardless if it is indentical to a previous one. I found under queries > design > properties there are two options unique values and unique records. According to a source online, these are what control allowing duplicates through, but I have swapped them around with no luck. Currently they are both set to "no".

Is there some other setting I have to switch up in order to allow the duplicates to come through?

Thanks
 
Yeah, scratch this post. Just made an autonumber for the table to distinguish the records.

I'm REALLY rusty on this stuff. :/
 

Users who are viewing this thread

Back
Top Bottom