How can I calculate the percentage of a field in Access 2007?

[Lexzo]

Dear Sir/Madam,

I have table called PROUCTD and it have the following attributes that i want to calculate:

a) CIF_Value = $6000
b) Payment Rate = 0.03% of the CIF_Value
c) Total Cost = Anstwer

Thank in advance

Alex

[NeoPa]

Lexso, you don't have a question. This is nothing we can help with I'm afraid.

What I can do is suggest that you check your table name.

Are you wanting to produce these figures in a query, or do you actually have a table set up as you say and you want to update it? See Normalisation and Table structures for why the latter is such a bad idea.

[Lexzo]

Dear Sir/Madam,

Thanks for your reply. My question is how can i calculate three fields in table in Access 2007

eg.

The three fields are Product, CIF_Value (the CIF_Value is 0,03%) and Total Cost.

Inview of the above, I want to muiltiply the product field ($600) and the CIF_Value field (0.03% which is a fixed rate) and the answer put into the Toatl cost.

Thanks

Alex

[NeoPa]

That is no clearer.

You will not understand if you ignore what I say. Please reread my first post (#2) and try to produce something that we can respond to.

[Lexzo]

Thanks,

The table in question is the Product table.

I have two fields in above product table called CIF_Value and Payment rate. I want access 2007 to automaticall calculate the two fields and produce the answer in another field called total cost on the same product table. Note the payment Rate field if fixed (0.03%) but the CIF_Value can contain any number.

I hope my question is understood now.

thanks

Alex

[NeoPa]

@Lexzo
Yes. Your question makes sense now.

However, before I go and knock something up to illustrate how this can be done, I must warn you that this is strongly recommended against! This is absolutely not a good way to use Access or any database. It will cause you problems in the future! See the article linked in post #2 for the explanation why this is so.

As I said, I will give you the information you request now that I have made it clear that I think it's a very bad idea.

[NeoPa]

@NeoPa
Your query will have SQL very similar to :

UPDATE [Product]
SET    [Total Cost]=[CIF_Value]*[Parment Rate]