A simple calculated field

[kev88]

Hi,

I have a simple table where I want to insert a calculation.

I have the following columns - "Quantity" and "Unit Cost"
I'd like a "Total" column which gives the Quantity*Unit Cost to give the total. How do I go about doing this?

http://allenbrowne.com/casu-14.html

I read on the link above that Access 2010 has a "Calculated" data type - but I can't see it despite having this version. I see many other Access 2010 users couldnt find this data type aswell - any suggestions?

Thanks very much for your help

 

[pbaldy]

It's not in the dropdown?

 

[pbaldy]

By the way, you haven't saved it as an mdb have you? It would have to be an accdb to see the calculated field.

 

[kev88]

That might be it.

How would I save it as an .accdb?
I went to the "Save As" bit and typed in Project.accdb since the ".accdb" option wasn't there (just Microsoft Access Database). Then went back into it but I have the same problem as before.

Thanks for your help

 

[pbaldy]

It would be down in Save & Publish.

 

[kev88]

Ok, I tried that but that particular option is blocked out?

http://i41.tinypic.com/4sywt1.jpg

Thanks again

 

[pbaldy]

It's the one that's highlighted ("Access Database"); is it blocked?

 

[kev88]

Got it - thanks very much for your help. That box wasn't blocked out

 

[pbaldy]

No problem; got your calculated field now?

 

[kev88]

Yes thanks.

Although, I'm now having trouble trying to calculate the total of each invoice to be displayed in a column of another table

For example, say I wanted to display the total of invoice ID 10264 in another table, how would I go about doing this?

http://tinypic.com/r/99nh9e/5

 

[pbaldy]

I don't know that you can do that with a calculated field. You typically wouldn't save that value anyway. If you really wanted to, you may be able to do it with a data macro. Otherwise you're probably doing it yourself.