If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|