ElseIF Statements Help

[jbeling]

Open a new query, go to SQL View and copy/paste it there.



See above.



No, you can call it whatever you desire.



Once you've copied/pasted into SQL view, switch to Design view. You'll see the fields and the criteria as though you'd entered them in Design view.

After running the query, open tbl_Expire and you'll see that StatusID has been updated.

Bob

It worked! So the new query I made is called an update query? IS this something I should have to run all the time or was it just a one time deal?

Thank you for all your help!

 

[raskew]

Hi -

IS this something I should have to run all the time or was it just a one time deal?

You'll need to run it frequently since the relationships between Exp_Date and Date() will change daily.

Bob