print selected columns in query

[Guest]

When I run a query I sometimes only need to print a few columns, not all of
them. They are not adjacent to each other.
Is there a way to do this?

 

[John Spencer]

Method 1) Change the query to hide the columns

Method 2) Change the query and drop the columns

Method 3) In datasheet view,
-- select Format: Unhide columns from the menu
-- uncheck the columns you don't want
-- Print the query
-- Close the query and DO NOT save the format changes

Method 4) Click on the divider line between the column headings and drag the
column widths to zero (again when you close the query, DO NOT save the
format changes

Method 5) Use a report and design the report to only show the relevant
columns

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..