 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / September 2006Place Holder in a Query
What do you put in the field when you want to create a place holder for a column, so that if you export to an excel file it only adds the columns you need from the query?  SignatureThomas hi, You can add a column to the query retrieving all results from the table you want to export to Excel, and put any value you wish into rows for this new column. The rows only with a specific value or range of values would be exported. Hope this helps. > What do you put in the field when you want to create a place holder for a > column, so that if you export to an excel file it only adds the columns you > need from the query? Hi, But I am thinking I don't want the header to show in the excel file, that column is blank and already has it's own header. So, I thought the placeholder i.e. the "new column" had to have an expression or something so that it would not overwrite the column in the spreadsheet? SignatureThomas > hi, > [quoted text clipped - 8 lines] > > column, so that if you export to an excel file it only adds the columns you > > need from the query? Hi, Umm..you don't have to export the new column... For example, SELECT test.city, test.num FROM test WHERE (((test.num3) Is Not Null)) GROUP BY test.city, test.num; In this query, columns [city] and [num] are retrieved by the query (and possibly exported to excel). Note that there is a where clause for the [num3] column, which determines which records to select/export. Since [num3] is only in the WHERE clause, it will factor into the results but not retrieved/visible/exported. Hope this helps, geebee > Hi, > [quoted text clipped - 15 lines] > > > column, so that if you export to an excel file it only adds the columns you > > > need from the query? Add to the SELECT satatement like this -- SELECT test.city, test.num, "XX" as [My New Column1], 0 as [My New Column2], Null as [My New Column3] > Hi, > [quoted text clipped - 33 lines] > > > > column, so that if you export to an excel file it only adds the columns you > > > > need from the query? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.