Check if the Results of two fields match? (1 Viewer)

[Number11]

what's the best way to say if two fields in query match

[ID]=[SID],Yes,No ?

 

[plog]

FieldName: ID=SID

 

[theDBguy]

FieldName: ID=SID

That will work and give you either -1 or 0. If you prefer "words" as the results, you can use the IIf() function. For example:

AreTheyEqual: IIf(ID=SID, "Yes", "No")

Hope that helps...

 

[CJ_London]

Or use the format property

 

[theDBguy]

Or use the format property

@CJ_London, can you please provide an example? Thanks!

 

[CJ_London]

sure - this in a query, same format to use in a form or report

or add a bit of colour

result

 

[theDBguy]

sure - this in a query, same format to use in a form or report
View attachment 98094
or add a bit of colour
View attachment 98095

result
View attachment 98096

Thought so. Thanks!