expression where data is the same

[Guest]

for example i have a phone number field and an 800 phone number field
phone 800 phone expression
800-571-1234 800-571-1234 800-571-1234
717-234-5678 800-231-1234

i just want to pull the ones that are the same in an expression

 

[Rick B]

Under the 800 phone field, enter the following in your criteria...


=[Phone]

 

[Guest]

Try this

Select [phone], [800 phone] , iif([phone] = [800 phone],[800 phone],"") as
expression From TableName