I have a query based on another query. The source query has two number fields and only one row. ONE of those fields is selected as a field in the new query, and uses it for 5 additional calculated fields, for a total of SIX. When I run the query, however, there are SEVEN fields, one of which is the second field in the source query. This field is not showing in the selected fields in Design View!
I know it can work the other way around . . . there can be more fields in View because one can uncheck a field in the "Show" row in Design, but this is a new experience.
Ideas? Thx
I know it can work the other way around . . . there can be more fields in View because one can uncheck a field in the "Show" row in Design, but this is a new experience.
Ideas? Thx