Debbie link
Last Activity: Sep 13 '10, 05:11 PM
Joined: Aug 10 '10
Location:
-
Debbie link replied to I have a query that is exporting to excel. How do I hide the null columns on the excin AccessI wrote a union query that combines 3 columns into 1 column. The 3 fields that made up the columns have names. When I run the query I get the right results (see I had criteria). How on the query can I can the column name to the right criteria selected. I know I can not explain myself well and it may not be possible but thanks. -
Debbie link replied to I have a query that is exporting to excel. How do I hide the null columns on the excin AccessI have a query that has a column with null values so I am exporting it to an excel spreadsheet. My code to export to an excel spreadsheet is DoCmd.OutputTo acQuery, "QryFSforOutput ", "MicrosoftExcel Biff8(*.xls)", "", True, "", 0
Is there I way I can hide that column with null values in my spreadsheet when it opens?Leave a comment:
-
Debbie link replied to I have a query that is exporting to excel. How do I hide the null columns on the excin AccessI have an access query that I am export to a excel spreadsheet. I the query there is a column with all null values. I can not hide that query column since it has all null values. So on the excel spreadsheet when it opens can the column with the null values be hidden. My code to export the query to an excel sheadsheet is DoCmd.OutputTo acQuery, "QryFSforOutput ", "MicrosoftExcel Biff8(*.xls)", "", True, "",...Leave a comment:
-
Debbie link started a topic I have a query that is exporting to excel. How do I hide the null columns on the excin AccessI have a query that is exporting to excel. How do I hide the null columns on the exc
I have an access query that is outputting to an excel spreadsheet. How do I hide the null colmns on the excel spreadsheet when it opens. Thanks -
in a query how to you hide a column if it is null
in microsoft 2003 access I have a guery. One of the columns is null how do i hide that column
No activity results to display
Leave a comment: