[parrothead16]

Greetings. I have an Access Query that contains 5 fields. I only want Field 5 to display is Field 4 matches Field 3. I am having a difficult time with this and something tells me I trying to over engineer it. Can anyone suggest some ideas how to accomplish this task? Thanks.

[Advertisements]

sorry i don't run many queries in access (sql is easier) but are you creating a query in "design" view within the database?

if so you would put the field that you want displayed (field 5 in your description) in the field section
then in the criteria you would simpy put "where field4 = field3" then save and run the query

[dsenette]

sorry i don't run many queries in access (sql is easier) but are you creating a query in "design" view within the database?

if so you would put the field that you want displayed (field 5 in your description) in the field section
then in the criteria you would simpy put "where field4 = field3" then save and run the query

[dsm]

parrothead,
You can use an iif statement to acheive the outcome you have stated.
The iif statement has 3 parts a logical test , value if test is true , value if test is false.
In the area where you would normally drag and drop fields to be displayed in the query type the following.

MyLabel: IIf([Field3]=[Field4],[Field5],Null)


hope this helps

dsm