Working with queries

[wekesa]

am having a farm produce database containing customers deatails table, product quantity table and price per quantity table. i want to come up with a query that will automatically show total amount of product when inputed by prforming some caculations. and in the query i want to introduce a new field called PRICE which is toal amount i want to be calculated. please help me how to go about this one am a bigginer hopping to be an expert. thank you!

[ranman256]

in the query create a calculation :
ExtPrice: QTY*PRICE

(along with other fields needed)

[andy49]

In case you need a pic to help ranmans advice

[orange]

Please tell us more about your business in plain English.
If you provide a broad overview, then you may be able to include things in your design now - or at least allow for them and possible future growth.

How many Customers? How many Products? Do you ever have Sales (Specials/Clearout etc)?
Be cautious with Price - there are at least 2 prices to consider --- the Current Price of the Product and the Price at which you sold the Product (The Price on the Order/Invoice). If you record Orders/Sales, and you only use the Current Product Price, then
whenever you change the Price of the Product, all of your old Orders/Sales info will be affected.

Better to design your database, than simply get something working quickly.

This free data model may be useful.

Good luck with your project.