Query only showing specific records - i need all - please help
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
|