take prices in dbase and make new field with discounted price

[Robert Blackwell]

I have a dbase full with product information and prices. There are actually
2 price fields: Retail Price -& Sale Price.
I want to add a third field which is our price so I need a macro that will
populate the our price field based on some math.

The sale price fields may be blank since the manufacture does not always
have a sale price on some items as they may be limited time sale etc.

The math should be something like this

if
sale price = null
our price = retail price x .75
then round up to x.95 cents

else
our price = sale price x .75
then round up to x.95 cents

There's just a little over 2800 records in this table.

 

[Van T. Dinh]

If you *always* use the same algorithm to work out [Our Price], the you
should not save it in your Table. You simply work out [Our Price] whenever
you need it from the [Retail Price] / [Sale Price]. This way, your [Our
Price] is always accurate regardless of changes in the [Retail Price] /
[Sale Price].

 

[Robert Blackwell]

Yes, I will always use that same math to figure my price, but I need to do
it this once so I can export the dbase to xml for importing into a web
commerce site.

 

[Van T. Dinh]

There is no needs to store [Our Price] in the Table.

You can create a Query with the calculated Column [Our Price] and then use
the Query as the source for the export.