The Show check box in Queries what is it for

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I would think that "Show" would place the results in the table or not but it
appears that if you do not check the box the results cannot be used for
calculations in other parts of the query. Does "SHOW" mean "Ignore"?

As an example I have in the "Total" box "Count" in two places (qtyrcv and
dc1). The results of the two counts are used in an Expression that subtracts
them.
LotsAcc:[countofqtyrcv]-[countofdc1]. If I do not check the "Show" box the
query asks for the values.

As a side question is it possible for a query to create a table in Excel
versus me exporting the table to convert it to Excel?
 
The Show box means "show this field in the query results". If you don't show
it, the other calcualted fields can't use it because they're not contained in
the query. Sometimes you can have fields in queries that you just want to
filter on, but not necessarily show in the result set.
 
Back
Top