Returning A Value Based On Whether Or Not There Is A Duplicate Value

[Darla]

Hello everyone! I have a query that returns a value based on a value in another field of a table. However, I'd like to return a value based on whether or not "FieldA" has a duplicate anywhere in the table.



Ex: If FieldA = "Check Out", then FieldB = "Yes", Otherwise If FieldC has a value of "17" in more than 1 record in the table, FieldB = "No"


Is this possible? Am I trying to accomplish it the right way? Any direction or insight is helpful, thank you!

[Bob Fitz]

What if FieldA = "Check Out" and FieldC has a value of "17" in more than 1 record in the table

[Darla]

I don't really see any instances where that would happen in our situation.

[Bulzie]

If Me.FieldA = "Check Out", then

Me.FieldB = "Yes"

Else

If DCount("FieldC", "YourTableName", "FieldC = 17") > 1 then

Me.FieldB = "No"

End If

End If