Query Formulas

[ShadeRF]

I need to do the following on a query. I have a field we'll call Cost1 that I divide by .77 divide by field PackSize. I have another field called ReqPrice. I want to take the result of the first formula and subtract it from ReqPrice. If there is a difference, in other words, it doesn't equal 0 I want to output what number would need to be added/subtracted to the first formula so my 2nd formula equals 0. I hope that makes sense. Thanks!

[alansidman]

This might be easier to understand if you showed some sample data with field names and what the end result should look like.

[orange]

I agree with Alan. This doesn't make sense

Cost1 that I divide by .77 divide by field PackSize

[ShadeRF]

OK.

Fields:

LIC, PackSize, Retail - Let's assign 90 to LIC, 12 to Packsize, and 8.99 to Retail

Query:

SPACalc1: (([LICDistributor])/0.77)/([PackSize]) = 9.74
SPACalc2: ([SPACalc1])-([Retail]) = .75

Since SPACalc2 didn't equal 0, I want to find out what # to add/subtract to LICDistributor in the first formula so that the second formula will equal 0. Hopefully this clears it up

[hertfordkc]

X = Retail * Packsize * 0.77 - LicDist

[ShadeRF]

I neglected one peice of info on the formula. How would I adjust this in to fit your formula you gave me?

SPACalc1: (([LICDistributor])/0.77)/([PackSize])*1.30 = 12.66
SPACalc2: ([SPACalc1])-([Retail]) = 3.67

Still need to solve
LICDist-X/.77/PackSize*1.30=Retail(8.99)

[hertfordkc]

I neglected one peice of info on the formula. How would I adjust this in to fit your formula you gave me?

SPACalc1: (([LICDistributor])/0.77)/([PackSize])*1.30 = 12.66
SPACalc2: ([SPACalc1])-([Retail]) = 3.67

Still need to solve
LICDist-X/.77/PackSize*1.30=Retail(8.99)

-----------------------------------------------------------------------------------------------------------------------------
x = Retail * Packsize * .77 / 1.30 - LICDist