Is it possible to have two "trendlines"?

[June7]

Parameter would go in the WHERE CONDITION argument of the macro.

As I said, how the report opens should have no bearing on the BMI calc.

I manually calculated the BMI: 205*703/69^2 and get 30.3

Height is a reserved word. Access is not liking the field name and is doing weird things. I changed the field name to HeightInches and now the BMI calculates properly.

[dilbert]

OK, I added this to the query, problem solved.

([Weight]*703)/([Height]^2) AS BMI

[dilbert]

You have been an amazing help, again. I don't know how to mark an answer as the best answer, but I think you summed it up in post #10 best.

Thank you so very much!

[June7]

Good solution. I should have thought of.
Edited my previous post. Might review again.
Advise not to use reserved words as names for anything.

[dilbert]

Good solution. I should have thought of.
Edited my previous post. Might review again.
Advise not to use reserved words as names for anything.

Thanks, I didn't realize Height was a reserved word.

This has been fun, you are a great help.