Access query question
Posted 11 October 2006 - 12:33 PM
Posted 11 October 2006 - 02:10 PM
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
Posted 12 October 2006 - 01:16 AM
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.
hope this helps
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users