Calculation/Formatting Issue

denileigh

Registered User.
Local time
Today, 23:34
Joined
Dec 9, 2003
Messages
212
Hi All! Thanks to all your wonderful help I am slowly but surely getting there with our new database re-write!!

I'm trying to calculate a field in a query and having some syntax problems. Here's what I have....

MLabor: Format(Int([QuotePrice]/(100-[Markup]))*100,"0000000)

Can anyone help? I'm sure it's simple.
 
Try this:

MLabor: ([QuotePrice]/(100-[Markup]))*100


If not sure what the other text (Format Int "0000000) represents, I'm kind of new myself....Is the above text some kind of formatting?
 
I figured it out...this works:

Material: Format(Int([QuoteMaterial]*100),"00000000")

EXCEPT....it is rounding it up. For example 10.00 material x 10% markup is coming out on the form as 11.11 but when you put it in an append query to a table so it can kick out a 500character long string....it is rounding it to 1100 or 11.00.

I need it to calculate it and output as 00001111
 
OOps - I copied/pasted the wrong field....I've spent too many hours on this today. Here's what is working...sort of with the round up prob..

MMaterial: Format(Int([QuoteMaterial]/(100-[MarkUp])*100)*100,"00000000")
 

Users who are viewing this thread

Back
Top Bottom