Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by benisma

  1. benisma

    Format a drill down report out of pivot table

    I can do that in the worksheet, but then that gives 2 sets of numbers for the sales manager to look at in the drill down report. Can I take out the first set of numbers from the pivot table and just use the rounded #s? If so, how? I tried to reset what data my pivot table was using, but it...
  2. benisma

    Format a drill down report out of pivot table

    I have a "detail" report on one page of my workbook and a "totals" page with a pivot table for a quick refrence for all of the field personnel. The idea is for the pivot table to be looked at first, then the detail for further info if an issue is found. In the detail report, there are gross...
  3. benisma

    Trouble with sql in VBA, too much?

    Sorry, I am having such a rough time of it lately. I will work on the query.
  4. benisma

    Trouble with sql in VBA, too much?

    Skip, I am not absolutely sure of the number of query tables. I know that I built this query and this is the only thing on the page. On the next worksheet, there is a pivot table. But, I have built this out of an Access database that has 7 different queries linked to it. I am sorry I am being...
  5. benisma

    Trouble with sql in VBA, too much?

    Foe some reason, I can not get the query to refresh on the worksheet through VBA. I have tried: Sheets("detail").querytables(1).refresh worksheets("detail").backgroundquery.refresh The first that I tried was the Excel command .refresh background query:=false What can I use? It will save the...
  6. benisma

    Trouble with sql in VBA, too much?

    It worked!! Thank you all so much for your help.
  7. benisma

    Trouble with sql in VBA, too much?

    Now it is giving me an "expected end of statement" at the first line continuation. I have tried a variety of things, and can't get past this. I think it's probably something I am overlooking. Here is the first part until it stops me. range("C4").Select With Selection.QueryTable...
  8. benisma

    Trouble with sql in VBA, too much?

    Here is the begining of the code for xlbo: range("C4").Select With Selection.QueryTable .Connection = Array(Array( _ "ODBC;DSN=MS Access Database;DBQ=C:\Documents and Settings\jsneed\My Documents\work for fleet 1-2006.mdb;DefaultDir=C:\Documents and " _ ), Array( _...
  9. benisma

    Trouble with sql in VBA, too much?

    I am trying to put the following sql into VBA to run 134 different districts. SELECT cash.REGION, cash.DISTRICT, cash.STORE, cash.LINE, cash.IPLCD, cash.IPCODE, cash.cash_sls_total, 1-(cash.cash_cost_total/cash.cash_sls_total), installer.charge_sls_total...
  10. benisma

    Function not calculating the last row of loop

    Thank you all. I took the code from "vbap" and applied it as Mike and Skip suggested, worked like a charm. I really appreciate the help!
  11. benisma

    Function not calculating the last row of loop

    I wanted to do a sumif for a concatenated 3 letter code, product code and sub code(groups of parts). After finding the match, I wanted to sum cost on those items. I want it to look like this: Con cost cost sum WAL22 75.41 10858.78 WAL22 52.52 10858.78 WAL22 23.33 10858.78 WAL22 65.78...
  12. benisma

    Function not calculating the last row of loop

    I have 4 queries built into a spreadsheet. There is a lot of manipulations that happen after that. I have figured out how to loop and use the selection.offset to be able to handle the different sizes of data. The first 4 loops work just fine. The fifth loop, that I had to write a function for...
See more

Part and Inventory Search

Back
Top