Hello all,

It's my first database, and I have a query that shows me the quantity,
material, length, width and thicknesses of parts, and I'm using these
figures to do some arithmetic on a report to show me how many board
feet of lumber to buy (expression is as follows):

=([Length] * [Width] * [Quantity]/144) * (Val([Thickness])/4)

If you're wondering what the Val statement is for, it's to grab the
first number of a fraction that's recorded as a text field for rough
lumber sizes like 4/4, 8/4, 12/4, et cetera, and I use the first number
of that fraction as a multiplier. This may not be the best way to get
the number, but it's what I've come up with.

The data in the table looks right, and the query shows me the right
data as well. The problem seems to be in the report.

Everything about the report's expression gives me the answer I expect,
except the width field. For some reason, the expression always uses a
width value of 9360, regardless of the width data in my table. I have
no idea where this number comes from. It's not a value in any of my
tables, and is not a sum of any values either. As a test, I copied the
database, blew away all the data in the copy's table and the report
still came back with a width value of 9360. Even changing the
expression to =[Width] gives me 9360, but just Width (no equal sign or
brackets) yields the correct number.

I am very puzzled. If anyone can shed some light on this, I would be
grateful. Let me know if I omitted a crucial piece of information.

Jared Emery