Expression builders

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't seem to get the expression builder to work. To start, I'd like to
have a condition where IF one field = another field, THEN "good" will appear
in a new column I want to show, ELSE "bad" would be displayed. How can I do
this? Thank you.
 
It sounds to me that you want the IIf() function. If ... Else ... is only
for VBA and not in expression ...
 
Put the code below in the AfterUpdate event of [One Field] and change the
names of the fields in [ ] to your Form control names.

If (Eval("Me![One Field]= [Another Field]")) Then
Me![New Column ]= "Good"

Else

Me![New Column]= "Bad"

End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expression Builder 4
Expression Builder 5
Access Expression builder is missing fields 1
Hello happy new year to all, Text box input for year of purchase 0
Having Expression Builder troubles - HELP!!!!!!!! 3
Expression Builder shows old Form Fields ??? 1
Looking for Dmax function in Expression Builder 7
Inserting OnCurrent into Expression Builder 2

Back
Top