Search results for query: *

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.

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

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...

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

I am using Excel 2003

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

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...

Thank you. The cross tab worked great!!!

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...

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...

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...

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...

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...

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)...

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...