Calculation

[Tia]

Hi, I'm trying to have a field calculate a cost based on the following two
fields: (Price_Markup) and (Vendor_Cost). Price Markup is a number and
Vendor Cost is a currency. I tried having a simple equation in a query but I
kept getting an error message. Suggestions?

I need something that will do the following:

Customer_Price = Price_Markup * Vendor_Cost

Customer_Price is a blank field.

Thanks.

 

[Hindsey]

What is the error message you are getting?
Are you getting the error message in the query, when you open it?

 

[John W. Vinson]

Hi, I'm trying to have a field calculate a cost based on the following two
fields: (Price_Markup) and (Vendor_Cost). Price Markup is a number and
Vendor Cost is a currency. I tried having a simple equation in a query but I
kept getting an error message. Suggestions?

I need something that will do the following:

Customer_Price = Price_Markup * Vendor_Cost

Customer_Price is a blank field.

Thanks.

The Customer_Price field should simply NOT EXIST in your table.

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, by creating a Query based on
the table. In a blank Field cell type

Customer_Price: Price_Markup * Vendor_Cost

 

[Tia]

Okay, I guess I'm confused. I thought that I was putting this in a field in
my query. When I did this, I just got a blank field.

What I need is a cell that will calculate the product sale price using the
vendor cost multiplied by the markup for a particular customer. So if my
query has the following information:

Customer_ID Product_ID Vendor_ID Vendor_Cost Customer_Markup
Customer_Cost

I want the customer_cost to calculate based on the information in
Vendor_cost and Customer_markup. What is the best and most efficient way to
go about this? Does anyone know of any examples that I could look at?