Hi,
I am fairly new to Access and am not familiar with writing expressions or formulas in queries.
I need something that will tell me if my data in field A has the same information as field B.
TIA,
Tracie
Hi,
I am fairly new to Access and am not familiar with writing expressions or formulas in queries.
I need something that will tell me if my data in field A has the same information as field B.
TIA,
Tracie
Use an IIf statement:
If(this is true, then this, otherwise that) - the otherwise is optional
DoesItMatch: IIf(FieldA=FieldB,True,False)
or simply
ItIsAMatch:FieldA=FieldB
What is going to happen once you know?
I don't see either of the solutions posted.
If they match then ok if not then error
Either of the solutions posted will work, what is your question?
So what did you actually try which did not bring you any luck? As Aytee says - it is not in your screenshotSo far no luck, here is a screen shot of my query design. I need to know if field 4 is equal to field 9.
Is this right? Is the result supposed to be -1 if they match? Sorry, really new at this.
ItIsAMatch: [dbo_ORDERS]![CUSTID]=[dbo_UNITS]![CUSTID]
yes/no, true/false, -1,0 are all different formats of the same thing - a Boolean value. The value is actually -1/0 but can be formatted as yes/no, true/false
Thank you. this works then.