[RESOLVED] Need help

[landslide]

not sure how to do this but I want to create a quiry that is run only if a value is = to.

for example

select field1, field2
case
if field 1 = 90
then do this query
else
case
if field 2 = 90
the do this query


is this possible

[chris22]

Yes, it should be possible. Take a look at:

http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html

[landslide]

Thanks for the reply. I am trying to do this is MS access and it doesnt seem to reconize these commands. How would I do it? in Visual Basics? Thanks for replying to my origional email.