Unchecked show box deletes field

[carole]

We have a query with alot of fields that are used to
calculate a subsequent query. We do need to run this
first query often but don't want all the fields to show up
on the print out. When we uncheck the show box and save
it, the next time you go into the query, those fields that
had unchecked boxes disappear. This screws up the
subsequent queries.
Is there any way to fix this?
Thanks for any help.

 

[Wayne Morgan]

If there isn't anything for the field to do (i.e. sort, group by, etc), it
will be removed when you uncheck the show box. Also, with the show box
unchecked, even if the field stayed there it wouldn't be available to the
subsequent query because it would no longer be part of the queries output.

1) Make another query without the fields you don't want to show.

2) Make a report based on the query and only use the fields you want,
ignoring the rest of them.

3) Shrink the column widths so that the unwanted data doesn't show when you
are looking at the query, then print.

 

[Guest]

Thanks! We'll probably just make a report.

-----Original Message-----
If there isn't anything for the field to do (i.e. sort, group by, etc), it
will be removed when you uncheck the show box. Also, with the show box
unchecked, even if the field stayed there it wouldn't be available to the
subsequent query because it would no longer be part of the queries output.

1) Make another query without the fields you don't want to show.

2) Make a report based on the query and only use the fields you want,
ignoring the rest of them.

3) Shrink the column widths so that the unwanted data doesn't show when you
are looking at the query, then print.

--
Wayne Morgan
Microsoft Access MVP





.