How to create a calculation in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have a table with a qty field and a price field and I need to multiply the
two. I can do this easily in excel but in access I can't seem to type up a
calculation in the design view of a table. It gives me an error.

Any help would be greatly appreciated.

Thanks

Suzanne
 
Grd said:
Hi there,

I have a table with a qty field and a price field and I need to
multiply the two. I can do this easily in excel but in access I can't
seem to type up a calculation in the design view of a table. It gives
me an error.

Any help would be greatly appreciated.
Click to expand...

In databases you would not store this value in a table. Create a SELECT
query based on your table and in that query include all your fields plus a
calculated field ([qty]*[price]) to give you this result. Then use the
query every place you would otherwise have used the table.
 
Hi Rick,

Thanks very much. I was barking up the wrong tree.

S

Rick Brandt said:
Grd said:
Hi there,

I have a table with a qty field and a price field and I need to
multiply the two. I can do this easily in excel but in access I can't
seem to type up a calculation in the design view of a table. It gives
me an error.

Any help would be greatly appreciated.
Click to expand...

In databases you would not store this value in a table. Create a SELECT
query based on your table and in that query include all your fields plus a
calculated field ([qty]*[price]) to give you this result. Then use the
query every place you would otherwise have used the table.
Click to expand...
 
Hello,

I had the same question concerning calculations in tables, I followed your
sugestion, but how can the result in the select query be formated.
If I the qty looks like "3" and the price looks like "15.00" my result is
"45".
I want it to be "45.00".
Can you please help on this formating issue?

Thank you
Otrebla

Rick Brandt said:
Grd said:
Hi there,

I have a table with a qty field and a price field and I need to
multiply the two. I can do this easily in excel but in access I can't
seem to type up a calculation in the design view of a table. It gives
me an error.

Any help would be greatly appreciated.
Click to expand...

In databases you would not store this value in a table. Create a SELECT
query based on your table and in that query include all your fields plus a
calculated field ([qty]*[price]) to give you this result. Then use the
query every place you would otherwise have used the table.
Click to expand...
 
Back
Top