Using an Excel Formula in Access

[BEI77]

Hello, first time on forum and a novice in Access. We race stock cars and doing the chassis set up we rely on wheel weights telling us a lot about what to do to the car to make it better. I have an Excel formula that works great but I want to use it in my racing database. The formula works by telling it what the individual wheel weights are LF, LR, RF, RR and by entering the DESIRED CROSS WT. The result will tell you what each wheel should weigh. Please tell me where and how to use the following formula.



=If(Q68<>0,M61-((Q68-Q66)/100*M65/2,"??"))) this gives me the desired weight for the left front wheel.

Q68-DESIRED CROSS WT
M61-CURRENT LEFT FRONT WT
Q66-CURRENT CROSS WT
M65-TOTAL CAR WT

[June7]

Are those the field names in your table? Use field names in place of the cell references. The function in Access is IIf().

BTW, advise no spaces in naming convention.
Also upper/lower case (camelback) would be easier to read: CurrentCrossWt
Underscore is acceptable: Current_Cross_Wt

If you keep the spaces, enclose field names in [].

[BEI77]

Thank you for the reply. Yes those are field names, and thanks on the naming.
So do I put the formula in the table as a calculated field?

[June7]

I don't think calculated field in table will accept the IIf() function.

Use the expression to create a field in query or use the expression in textbox on form or report.

[BEI77]

Ok, thanks, I'll try that.

[BEI77]

I tried the formula in a text box on the form and got #Name?

[June7]

The form must be bound to table or query that has those fields. Set the form RecordSource property.