You're not being very free with your information are you :-)
You have not answered my fundamental questions:
>> What data do you have? And what are the fields in your table? <<
Let's say you have a Purchases table and it has fields such as:
InventoryID (identifying what was purchased)
PurchaseDate
SupplierID (identifying whom you bought from)
TotalPaid
UnitsPurchased
Then you could create a query based on this table with a calculated field.
In the query grid it would look like this:
CostPerUnit: [TotalPaid] / [UnitsPurchased]
Or you could create a form based on your table with a calculated control
(textbox). The ControlSource property of the textbox would look like this:
= [TotalPaid] / [UnitsPurchased]
Seriously though, if you want anything more than general help, we can't give
it to you if we need to guess what your table structures are like!
--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand
"distance" <(E-Mail Removed)> wrote in message
news:EF0FB1E1-0B3A-45F2-B3D1-(E-Mail Removed)...
> Graham,
>
> Can I do the calculation in a table or form, how do I do it???? Just
> started
> using access and am not sure how to calculate , will appreciate any help.
> (E-Mail Removed)
>
> Thanks
>
> "Graham Mandeno" wrote:
>
>> Yes, of course this can easily be done.
>>
>> But what information do you have? And what are the fields in your table?
>>
>> Let's say you know the total price paid and the number of units bought,
>> the
>> cost per unit is simply a division:
>>
>> [CostPerUnit] = [TotalPaid] / [UnitsPurchased]
>>
>> Is this what you mean?
>> "distance" <(E-Mail Removed)> wrote in message
>> news:38076ACB-C912-4140-84B8-(E-Mail Removed)...
>> > Please send me an email to (E-Mail Removed)
>>
>> Why? The whole idea of a newsgroup is that the whole community benefits
>> from the answers posted here.
>>
>> > Thank you.
>> --
>> Good Luck!
>>
>> Graham Mandeno [Access MVP]
>> Auckland, New Zealand
>>
>>
>>
Similar Threads
