Macro to Update Field based on Info in Another Field

  • Thread starter Thread starter Steve Davis
  • Start date Start date
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
 
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?
 
Back
Top