Creating a Calculator, please help :D

[Jack W via AccessMonster.com]

Hi,

I'm trying to make a fairly simple calculator in Access. Basically, it will
need to calculate the value of a change in price for different assets which
all have a unique multiplier.

Example, asset a has multiplier of 10, price 1 was 100, price 2 is 15, number
of assets is 2, thus value is (15-10)*10*2= 100

So basically I was going to have a table which just had the asset, it's
multiplier and it's currency. Then I would want to enter the two prices on a
form as well as the number of assets (all in a seperate box) then have a
button that you press to calculate the difference. I'm having trouble making
the form work (not very good with VBA), should the price1 for eg be in a
label or text box or what? What would be the best way to show the
calculations, ie have a query run or a label which just calculates it. Am I
missing anything simple like extra tables I need?

Any advice would be extremely helpful. Cheers.

 

[PC Datasheet]

You need a table that looks like this:

TblAsset
AssetID
AssetName
QuantityOfAsset
Price1
Price2
Multiplier

Then you need a query based on this table that includes all the fields in
TblAsset.
Add the following to the first blank field in the query:
AssetValue[Price2] - [Price1])*[Multiplier] * [QuantityOfAset]

Finally create a form based on the query and include all the fields in the
query. When you enter Price2 in the form, AssetValue will automaticallt
calculate. When you leave the record or close the form, Price2 will be saved
to TblAsset. The next time you open the form, Price2 will be there so
Assetvalue will immediately calculate. If you want you can change Price1,
Price2, Multiplier and/or QuantityOfAsset and and AssetValue will
recalculate to a new value.

Why don't you take Salad's advise and grow up and get a life and quit
sending emails to my office.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.

 

[PC Datasheet]

Randy,

Why don't you follow the advise of David Fenton ---

"Stop. I'm on the verge of killfiling the bunch of you who are
polluting the newsgroup with theis bitchfest."

Also tell your friend Arno R to stop sending emails to my office!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.

Why don't you take Salad's advise and grow up and get a life and quit
sending emails to my office.

?????
Must have been meant for someone else isn't it ??

Arno R

 

[John Marshall, MVP]

Randy,

Why don't you follow the advise of David Fenton ---

"Stop. I'm on the verge of killfiling the bunch of you who are
polluting the newsgroup with theis bitchfest."

Yes you should kill file all those people who are tired of you abusing the
newsgroups. Then we would not have to put up with your childish rebutals.

John... Visio MVP

 

[PC Datasheet]

Why don't you take Salad's advise and grow up and get a life and quit
sending emails to my office.

"If you have anything to contribute to the group, contribute. Your war
with Datasheet is simply pissing and moaning in the wind for the sake of
nothing. Grow up and get a life."

Salad

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.

Randy,

Why don't you follow the advise of David Fenton ---

"Stop. I'm on the verge of killfiling the bunch of you who are
polluting the newsgroup with theis bitchfest."

Also tell your friend Arno R to stop sending emails to my office!!!

So now you are answering Randy for something I wrote??
Can't you read? You know my name is Arno R

Must be very confusing for you these days ??
You are getting lots of emails? Show us another ONE.

Arno R