Help with a basic IIF query please

[EffBee]

Hello,
I have fruit table, personToFruit junction table and a Person table.
Fruits are Apples, bananas and pears.



In my query I would like to identify who has more than one fruit (each person should only have 1 if any).

I have created a new field in the query asking if Person has apple&bqnanas Or apple&pears Or Etc, then "Flag" otherwise "". But doesn't work.

Any help is appreciated.

Thanks

[June7]

This is your real database? fruits and persons? How would multiple fruit be entered? Separate records?

[EffBee]

Yes, in the junction table.
Person1, Apple
Person1, Pear
Person2, pear
Person3, Apple
Person3, Banana

[Minty]

A simple count of persons would give you what you need. Air SQL untested

SELECT Count(PersonID) as FruitQty, PersonID FROM tblPersonFruit GROUP BY PersonID Having Count(PersonID) >1

[June7]

If persons can have only 1 fruit associated there would be no need for a junction table. Don't understand issue.