Michael, Thank you, but I am still lost. I substituted your first formula
into my nish field and I am getting a calculation. The problem is that I want
to see all the data that I entered into the database. I am missing 7 records
because they did not require me to enter anything into the Length/Width
fields. I see all that data in the tables, bit not in the form/query. Is it
possible to fix? or should I erase them from my tables and reenter those
records?
"Michel Walsh" wrote:
If there is no finish rate defined, what would be the result?
You can use:
=Nz( [Finish Rate] * [Copies Requested] * iif( [Finish Square Foot]="X", [Sq
Ft], 1), "undefined" )
which will display "undefined" (without quote) if any of the three fields
is not defined.
You could also have use a Format to format the NULL values as displaying
"undefined" instead of the blank you should see at the moment when a null is
involved in the computation.
Vanderghast, Access MVP
"Yula" wrote in message
news
I have a combo box in a form (Based on a query) that looks up values in the
Finish Lookup table. The table has the following info:
Finish Description Finish Rate Finish Sq Ft
Coil .45
Cutting 0
Foam 3.50 X
Folded 0
Lamintated .218 X
The next text box has
length
Width
To get the finish cost I have the following formula:
=IIf([Finish Square Foot]="X",[Finish Rate]*[Sq Ft]*[Copies
Requested],[Finish Rate]*[Copies Requested])
After I add new records, I only see the records where I choice a finish
description that has a finish rate associated with it, I do not see all
records with the zeros for the finish rate. What confuses me is that I see
all the tables being populated with all the info that I enter (0 rate
descriptions and actual rate descriptions)
I have to present all this info today and I have no clue why the query is
only showing those records with the rates associated with them. I don't
have
any criterias set up.
Thanks so much,
Yula