Lookup Question

[Aspire]

Hello, and thank you for taking a look at my problem!

There are four fields of relevance: [tblVeg].[Vegetable], [tblPrice].[PriceID], [tblPrice].[Price], [tblPrice].[DatePriced]. There are hundreds of different vegetables, and thousands of days that constitute the primary key [PriceID] value.

Every day, all the vegetables get a new price; unfortunately, certain vegetables have never been priced. Some have been given a price at least once, so I don't care about those. How do I find out which vegetables have never been given a price?

I tried my hand using Dlookup, but it keeps returning vegetables that have been priced.

Thank you very much - I appreciate your brilliance!

 

[pbaldy]

If my guesses about your structure are correct, try the unmatched query wizard.

 

[Aspire]

If my guesses about your structure are correct, try the unmatched query wizard.

Thank you for that. I'd never used it. While it didn't give me exactly what I was looking for, it did find about a dozen orphaned records. I will work with it some more using different variations and see if I can get what I need.

Thanks again!

 

[pbaldy]

Happy to help!