Simple calculations to be shown in reports

[Newaccessuser]

Hi,

I'm totally new with Micorsoft Access.. My question is simple but before that, heres the situation

"I created a database which contains the Item price, its quantity and the cost price."

now for the question.... How do I apply the formulas which would multiply the quantity with item price and show the total value and then show it in the report that is being generated...i know its done through query but how. I can do it in excel, but i dont know how to do it in access.



Plz help.....


Regards,
NewAccessUser

[RuralGuy]

Are you trying to have an inventory report that prices out you inventory? The calculation can easily be done in a query that would then be the RecordSource of your Report. You would create an additional "field" in the query similar to:
LineValue:=[ItemPrice]*[Quantity]
...using your actual field names of course.

[Newaccessuser]

Yes that is what i'm basically looking for.Thankyou for this, however i'm still new to access and dont exactly know how to design a query, i keep having errors... Okie heres what i have and what i want. I have a field 'Quantity' in my table, The price is not in the table, its what i wanna write when i apply the formula.... this is what i want.

I want that when generate report, it should automatically show the calculated prices, where as at the time of data entry i am only entering the quantity (Price will obviously be added by me in query as a numeric value).... but how to go about it.

[RuralGuy]

I want that when generate report, it should automatically show the calculated prices, where as at the time of data entry i am only entering the quantity (Price will obviously be added by me in query as a numeric value)

I'm afraid you lost me on that. "adding a price in a query"? I'm not sure what you are trying to achieve. Obviously you are not extending your inventory costs as I first thought.

[Newaccessuser]

okie, suppose I have a value 30 and i wanna multiply every value in the field "Quantity" with 30 to to get my desired result. How do i do that in a query ? can i do that in a query ?

[RuralGuy]

Where do you want the result?

[Newaccessuser]

in a report that I generate.

[RuralGuy]

It would still be something like I described in post #2 except you would probably reference the form that is driving the report:
LineValue:=[Quantity]*([Forms].[YourForm].[YourValueControl])
...Using your names of course.

[Newaccessuser]

okie, let me try and i will get back to you.