Making a one time function

[Guest]

I made a database for travel expenses. Each trip had a field for "meals" and
one for "lodging". Now the people using the database have decided they want
both to be combined in a single field called "subsistance".

I would assume that I need to add lodging to meals, and set meals equal to 0
for each entry in the DB, and then change the name of lodging to subsistance.
How do I create this so that it will only run once? I can't find a way to
implement it...

Thanks

 

[Guest]

I don't think you need a function. I would suggest an update query that
would add the value in meals to the value in lodging and update meals to 0.
Then, go into the table in design mode and change the name to subsistance.
Am I oversimplifying this?

 

[Guest]

Genius! Worked like a charm.

I don't think you need a function. I would suggest an update query that
would add the value in meals to the value in lodging and update meals to 0.
Then, go into the table in design mode and change the name to subsistance.
Am I oversimplifying this?