Access query question
Started by
parrothead16
, Oct 11 2006 12:33 PM
#1
Posted 11 October 2006 - 12:33 PM
#2
Posted 11 October 2006 - 02:10 PM
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
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
#3
Posted 12 October 2006 - 01:16 AM
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
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
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users