Search results

  1. T

    Where Clause with Constant and Variable value

    What I'm trying to accomplish is to add constant footnote at the bottom of each output before it is exported in excel. My current SQL statement without the footnote is below. strSQL = "Select Account, Reseller, [AT&T],Comcast, DataXoom, [Spectrum-TWC], [T-Mobile],[Verizon Wireless], [Verizon...
  2. T

    Excel Formating on Docmd

    I'm wondering if I can do some editing to an excel file either during one of my docmd modules or if this is something I have to do afterwards. Module 1: Docmd.outputto Runs query and outputs to excel (xlsx) with a specific file naming convention "AccountNumber_AccountName_Month_Year". In...
  3. T

    Access External Excel Data

    Hello, I'm linking external excel files to an internal db but the external file has dynamic headers. Example. I always need to use Column R which is currently titled "September Activations" Next month Column R will read "October Activations". Is there a way that when i update the linked...
  4. T

    Export to Excel

    Brand new, so please excuse my inexperience. I'm trying to do two things. 1) Using the Code below, I'm attempting to create a new excel sheet that isolate each account number and exports that account's summary to an excel sheet. I'm currently stuck either in my SQL or vba statement how to have...
Top Bottom