New To Access

[Panzer336]

Hi there I am relatively new to Microsoft Acces (I am an Excel User), what i would like to try and do on a simple asset database that i am creating is to calculate the Total Stock Held by multiplying that figure by the field Cost. i.e. 10 (Total Stock held) * 5 (Unit Price) = £50 stock value

Any suggestions please

thanks
Sandy

 

[ghudson]

You can do that in a query, form or a report. You should not store calculated values in a table. Pay attention to how you name your obects. This might help... About calculations in a query

 

[AccessBlaster]

Also if you decide to create a "Asset Number" do not use the auto number for that purpose. You can search incrementing numbers in this forum. Good luck with your project.

 

[John Big Booty]

Access is quite a different beast to Excel, so you will have to develop a whole new way of thinking about how you approach things in Access as opposed to Excel. One key topic that you will need to get your head around very quickly is Database Normalisation. Good luck and have fun.