I have a query that uses fields from several tables. I then derive 2 fields: Units and Revenues inside the query: Units: [Field1]*[Field2], and
Revenues: [Units]*[Price]. In this last field derivation, Price field comes from the table, and Unit is internally derived field. Everytime I click on the query a parameter form pops up for the Units. If I just click OK to go to the datasheet view, all the derived fields are correct. But WHY IS THIS field keeps popping up everytime I open the query???
Can the derived field inside the query be reused to derive another field?
Revenues: [Units]*[Price]. In this last field derivation, Price field comes from the table, and Unit is internally derived field. Everytime I click on the query a parameter form pops up for the Units. If I just click OK to go to the datasheet view, all the derived fields are correct. But WHY IS THIS field keeps popping up everytime I open the query???
Can the derived field inside the query be reused to derive another field?