Making a one time function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 15 Apr 2005 19:33 GMT

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

Reply to this Message

Klatuu - 15 Apr 2005 19:57 GMT

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?

> 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
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Scott - 15 Apr 2005 20:11 GMT

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.
[quoted text clipped - 11 lines]
> >
> > Thanks

Reply to this Message