calculating a mark up

[heart01]

Hi all seems I need a life but here goes...if i have a field "cost per unit" <--- which is calculated already from dividing the total cost by the qty how can I or can I put in a calulation wherby the user can place say a 30% mark up on the cost per unit and have access automatically calculate...the mark up will be dynamic hope this makes sense

kind regards in advance on your support

[code green]

What are you asking?
If you have

"cost per unit" <--- which is calculated already from dividing the total cost by the qty

why is a simple multiplication so much different?

[heart01]

Well I think Im totally confusing myself I now have boggled eyes as I am working on trying to update fields and the above automatic calculation anyways I guess what I am trying to do is this

On the form I have the following text boxes

cost per unit
Mark up cost (which is set as format percent)
total with mark up

so what I am trying to achieve is if the user places a figure in the cost per unit and then a percentage in the mark up cost I would like if access could automatically place the total in the total mark up box...

As I mentioned I am so boggled now nothing is seeming to make sense...

[NeoPa]

At the risk of embarrassment, the formula for the [total with mark up] control would be :

=[cost per unit] * [Mark up cost]

[code green]

I'm glad you did that NeoPa, I was tempted to suggest

price =[cost per unit] * 1.3 
 

For a 30% markup but did not beleive this was the question

[NeoPa]

If that was a subtle way of pointing out my error then, well done. I probably didn't need my face rubbed in it.

However, a mistake there was in my post. I should have paid more attention to the fact that it was a mark-up rather than a Tax or other fractional formula. The answer should have been :

=[cost per unit] * (1 + [Mark up cost])

NB. If [Mark up cost] is displayed as a percentage as stated, then it would display as say 30%, yet the value would not be 30, but 0.3. If we were dealing with a value of 30 to represent 30% then we would need to divide this value by 100 before use.

[code green]

If that was a subtle way of pointing out my error then, well done. I probably didn't need my face rubbed in it.

You are very touchy today.
I was praising you for being brave in answering what seemed to be the obvious as I didn't have the courage to do so.
Nor did I consider your answer to be wrong, simply a different way of working.
By the way, have you figured out what the OPs question is yet ;)

[NeoPa]

You misunderstand me.

I was complimenting you on bringing the point to my attention, while at the same time avoiding any embarrassment for me. If that was accidental, then it was a happy accident. I was far from put out by the comment. My only embarrassment was that I'd made the mistake in the first place.

[thelonelyghost]

it sounds like you two answered the question. With what little I know about VBA and such I'd say you nailed what he was asking. Here's what I understood from heart01:

Problem: Basing the value of a field on an equation (see below) that takes into account another input: price markup.

Formula: [dblTotalCost] / [intQty]

If that is indeed the question, your answer of:

=[cost per unit] * (1 + [Mark up cost])

would be correct. Now I wonder where that formula would be entered.

EDIT: Asked and answered. Input the code above into the control for [total with mark up]

[NeoPa]

I expect you're right. It's down to the OP to make the question clear though really. Having experts spend their time trying to guess what is meant is not good use of their time. It seems a shame to waste the time of people volunteering to help you. This is the message that I'm hoping to get across.

On to your clarification question though, I'm sorry if that was not clear. From the OP's post #3, it would go in the control called [total with mark up].

[thelonelyghost]

@NeoPa
Is there a +rep button in this forum? LOL! Your help really is appreciated, on behalf of the OP and people like myself. I know I'd be asking that one guy in the office who is really good with Access every few minutes to help troubleshoot this. I'm glad this forum is here. (n_n)

I must have missed the part about the control box. I see what you're referring to now and will edit my above post to reflect that.

[NeoPa]

thelonelyghost: Is there a +rep button in this forum? LOL!

I believe it's being considered for implementation soon.

PS. Don't worry about missing a detail here or there. When you have so much to read through and nothing concrete to look at it's only natural you'll miss something from time to time. I do so all the time. Hopefully it's only a small percentage overall, but it's there nevertheless.

[heart01]

a really big thanking you to all...I am the knucklehead from lack of training and understanding. I thank you all for your input and time and efforts.

I think someone mentioned i was male...guess again LOL...kind regards Deb...

[NeoPa]

Welcome to Bytes Deb!

I don't think I would have been inclined to opt for male with an ID like Heart01 ;) It's possibly unfortunate, but I know very few men/boys who would have the courage to use such an ID.

[thelonelyghost]

@NeoPa
I was thinking the same thing, yet it seems that people on forums such as these (or any technical forum, really) are predominantly male. I try to use a gender neutral pronoun such as "(s)he" or "they" if it isn't absolutely obvious. There's no hating on the women who wanna be tech-saavy, in fact I encourage their propagation!

[NeoPa]

Propagation eh? Sounds like you're getting more into sex here than gender :D

PS. Don't worry. I'm just kidding. I know what you meant really.

[thelonelyghost]

@NeoPa
Well I am still a teen (see my profile) so that is on the brain, but we both know that's not how I meant it. poor choice of words is all...