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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dbrackeen

    Pivot Table grouping

    Thanks everyone. Andrea that was exactly what I was trying to do and couldn't for the life of me remember how to do it.
  2. dbrackeen

    Pivot Table grouping

    I'm not sure how to work with macros. I am a very basic excel user.
  3. dbrackeen

    Pivot Table grouping

    Hi, I'm sure this has been asked, but don't even know how to look it up. I have a spreadsheet that needs to have a pivot table created off it. The data looks like the following: Workflows Loan # Age The Row will be the workflows, the column will be the age and the data will be a count of...
  4. dbrackeen

    Different Rows repeated in Excel

    Thanks, that is what I was thinking, but thought I would ask, just in case.
  5. dbrackeen

    Different Rows repeated in Excel

    I am using Excel 2003
  6. dbrackeen

    Different Rows repeated in Excel

    Is it possible to have different rows repeat after a couple of pages? Basically I need rows 1-3 repeated on pages 1 & 2 only and then 2 different rows to print on page 3+. I hope this makes sense. Thanks Dianna
  7. dbrackeen

    Importing Data from Excel Spreadsheet/Text files

    I know this has been asked to death, but I know nothing about VB and am trying to get these to work. Basically I need to import a spreadsheet everyday into access. The spreadsheet has a diff name everday (for the date) and every month it is put into a new folder on the network. I would like...
  8. dbrackeen

    Summary of a summary

    Thank you. The cross tab worked great!!!
  9. dbrackeen

    Summary of a summary

    Hopefully I can explain this clearly... I have created a report that is grouped by Investor and then by Month and shows how much money was collected each month by each investor. I need for my grand total of the report to also be broken down by month instead of all lumped together. Thank you...
  10. dbrackeen

    Is it possible to...?

    Thanks, that does make more sense. Now the problem I have is one id may have muliple fees attached to it. Say 1 id has 3 fees, so then 3 reports print out. What I would like to see is a list of those fees on the report. Whether it is 1 fee or 5 fees. Then take a sum of the fees and add it...
  11. dbrackeen

    Is it possible to...?

    Thanks, I'll try the 2 details section. The reason I have the subreport in the details is because it is like a small table of fees. I basically have the primary report and then a box with the fee information. It is based off of id number and any id can have multiple fees or no fees. Basically...
  12. dbrackeen

    Is it possible to...?

    They are both in the details section of the primary report, but the subreport is below the field I am try to create. I tried to put the field below the subreport and that didn't do anything. I really need both fields in the details section of the primary report. Unless I could put the...
  13. dbrackeen

    Is it possible to...?

    Okay, I've tried everything I can think of and cannot get it to work. I have taken the sum of a field in my subreport and made it a currencyvar (shared variable). I then go to primary report and create a formula taking the shared variable + a parameter. It will only show the parameter amount...
  14. dbrackeen

    Is it possible to...?

    Thank you that makes so much more sense than the x=y stuff. It is almost working for me. I can get the shared variable in the subreport to bring up the correct amount (I'm using the currencyvar), but when I add that variable with my parameter (even tried another field that was not a parameter)...
  15. dbrackeen

    Is it possible to...?

    I understand that I need to learn how to use shared variables, so can someone tell me where/how I could learn this. My question is that I need to create a formula that takes the sum of the subreport and adds it to a parameter field that I have. That will then give me a balance. So I if I was...

Part and Inventory Search

Back
Top