Blank Queries are Producing Multiple Records

[Jennifer16]

Hello,



I have 7 tables. For some reason when I run a blank query, using query design, it is producing multiple records. Can someone explain why and how to resolve? This does not seem to occur when using Query Wizard. I'm hopeful that this is enough information.

Thank you so much

[Micron]

For some reason when I run a blank query, using query design, it is producing multiple records.

I don't understand that statement. What is a blank query? If that's one that returns no records, then how can that query produce multiple records? Did you add tables to the query design but not join them, or remove the automatic joins? That would make it a Cartesian product.

Then there is 'multiple' records. Most queries return multiple records, so that needs further explanation. You mean duplicate records? I didn't see any in your pic.

[Jennifer16]

Sorry, new to this...When I use Query Wizard. I get 1 set of records. However, when creating a Query using Design View, I get what is in the second photo. As you can see, there are multiple duplications of the same records: Smith, Johnson, Adams, Jennings, Nelson are being repeated along with the appointment dates.

[Jennifer16]

Just looked again. You're right. The records are not being dupilicated. They are just the results of different days. Sorry about that. Thank you for replying.

[Micron]

No problem. I suspected you were thinking that those records where duplicates, but wasn't sure because of your terminology.
You might want to research DISTINCT and DISTINCT ROW predicates as a related topic.

[Jamesy_007]

Hi Jennifer16 although i see you marked this thread as solved, you're right with this statement you jus need to put criteria's on your queries a patient can have many Appointment dates so you can use exg <#10/2/12 or >#10/2/12 to find the patients within a specific time frame am new also so if am wrong hope those guys that are very experience jump in... /QUOTE=Jennifer16;453618]Just looked again. You're right. The records are not being duplicated. They are just the results of different days. Sorry about that. Thank you for replying.[/QUOTE]