Feb 5 2008, 08:26 PM
Hi, i am a new access and ua user. Pardon my naiveness in asking the right question or making my question clear. I need all the help I can get. This is my problem. I would like to design a form that will ask the user for the item that was sold and how many units was sold in each quarter. The form will store only the item, unit price and units sold per quarter but must show in the form each item's total sales for each quarter in the continuous forms.
Feb 5 2008, 10:18 PM
A textbox with
=[UnitPrice] * [UnitsSold]
should display the result.
Feb 6 2008, 03:53 AM
Thanks for your prompt reply.
there will be many records and if i add another record and input the number of units, the previous records will inherit the new value. Ex.
Unit Price [1st Qtr] Amount [2nd Qtr] Amount [3rd Qtr] Amount [4th Qtr] Amount
Water Jug 500.00  2500  500  2000  -
Water Pitcher 100.00 
The value of Water Pitcher  will change the value of Water Jug  into . I hope the scenario is aatleast understandable, I think the post on 05-30-07 Subject: Recordset + unbound controls + continuous forms is the same as my problem.
Feb 6 2008, 03:26 PM
Can you post a sample db? I'm not understanding your structure. In a continuous form, I would expect the quantity and price fields to be bound. In that instance, a control like the one I showed would show the correct value for each record.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here