Can you use and "if" statement in a record set? Are there examples in any of the courses? Developer 16 doesn't show anything like that. Here's a use case: If I pull a value from a query using a record set and the value = "US*" I want to write it to an export file as "Americas". The csv file will be consumed by another application that needs this mapping.
Adam Schwanz
@Reply 4 years ago
Yes you can, you would say like
if rs!fieldname = whatever
'stuff
else
'stuff
end if
email me if you have issues xD
Teeka LeoneOP
@Reply 4 years ago
Thanks Adam!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 16.
