what's the best way to say if two fields in query match [ID]=[SID],Yes,No ?
N Number11 Member Local time Today, 18:22 Joined Jan 29, 2020 Messages 607 Feb 7, 2022 #1 what's the best way to say if two fields in query match [ID]=[SID],Yes,No ?
P plog Banishment Pending Local time Today, 13:22 Joined May 11, 2011 Messages 11,611 Feb 7, 2022 #2 FieldName: ID=SID
theDBguy I’m here to help Staff member Local time Today, 11:22 Joined Oct 29, 2018 Messages 21,358 Feb 8, 2022 #3 FieldName: ID=SID Click to expand... 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: Code:Copy to clipboard AreTheyEqual: IIf(ID=SID, "Yes", "No") Hope that helps...
FieldName: ID=SID Click to expand... 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: Code:Copy to clipboard AreTheyEqual: IIf(ID=SID, "Yes", "No") Hope that helps...
C CJ_London Super Moderator Staff member Local time Today, 18:22 Joined Feb 19, 2013 Messages 16,553 Feb 8, 2022 #4 Or use the format property
theDBguy I’m here to help Staff member Local time Today, 11:22 Joined Oct 29, 2018 Messages 21,358 Feb 8, 2022 #5 CJ_London said: Or use the format property Click to expand... @CJ_London, can you please provide an example? Thanks!
CJ_London said: Or use the format property Click to expand... @CJ_London, can you please provide an example? Thanks!
C CJ_London Super Moderator Staff member Local time Today, 18:22 Joined Feb 19, 2013 Messages 16,553 Feb 8, 2022 #6 sure - this in a query, same format to use in a form or report or add a bit of colour result
theDBguy I’m here to help Staff member Local time Today, 11:22 Joined Oct 29, 2018 Messages 21,358 Feb 8, 2022 #7 CJ_London said: 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 Click to expand... Thought so. Thanks!
CJ_London said: 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 Click to expand... Thought so. Thanks!