Macro to Update Field based on Info in Another Field

S

Steve Davis

I have a table that contains 2 relevant fields:

Grade | Points
A+ | 4.2
B | 3.0
etc | etc

I need a macro that basicaly says:

Do while not EOF(1)
If Grade = "A+" then
update [table.Points], 4.2
Elseif Grade = "B" then
update [table.Points], 3.0
Elseif etc....
Endif
Enddo

How should this be accomplished with a macro?

TIA
Steve
 
S

Steve Schapel

Steve,

Can you please explain a little more about what you are trying to
achieve. Sorry, I just can't quite grasp your meaning so far. How many
records are in this table? And where do these values of 4.2. 3.0, etc
come from? And is, for example, A+ Grade always 4.2 Points?
 

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

Top