Create a macro using if then statement to update a table

[sjacksontx]

I'm not sure where this question should be. I have a form (FOM) that uses a table (fom sum tbl) for it's record source. I want to create a macro or function (not at all sure how to write a function) that updates the fom sum tbl field [sponsortype] if the field [total amt] on fom sum tbl > 0 and < 25 then sponsortype = "Donation", Or if [total amt] > 24 and [total amt] < 50 then [sponsortype] = "Bronze". I know I could make several different queries that update the table but I was trying to not have to make that many queries (I have more conditions than above) and then have the macro open and close each query.



Can anyone help

THanks a bunch.

[ranman256]

in the macro , put update queries, each represents an 'if' statement. (there is no IF ...each has a different criteria for sponsortype.)

Qry1 = update sum tbl > 0 and < 25 where sponsortype = "Donation"
Qry2 = update sum tbl [total amt] > 24 and [total amt] < 50 where sponsortype = "Bronze"

[ssanfu]

I don't use macros - too limiting. (and I can't understand them)

So here is a demo that uses a table to store the different sponsor levels. The advantage of the table is that you can change the Sponsor levels and the minimum and maximum amounts. And you don't have to create a ton of queries