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

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

Originally Posted by NeoPa

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.

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

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.

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

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

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

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.

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

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

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

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.

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

Your query will have SQL very similar to :