Recent content by Kallen

Thank you so much. This worked perfectly and it wasn't half as difficult as I thought it would be. You made my week!

Thanks! I will give it a try and let you know how it goes. I am on my way to a meeting and will try it after! Thank you so much for all of your guidance. :)

To start there will only be two tables. One for December and one for January. This will be an ongoing project so I will take the tables for each month and compare them to the December table to see if any accounts were re-assigned from December to the current period. Sorry for the confusion.

Thanks for the quick response. All of the column names are the same in both tables. They are essentially the same, but contain different balance-$ info to reflect the end of each month. I name them DecBalance, JanBalance, etc. The column names that are the same and I will be using go as...

I am using Access 2000. This has been driving me crazy. I know there has to be a way to do it, I just don't know how. Here is the scenerio. We have thousands of accounts. Each account is owned by a sales officer. In January we re-assigned a bunch of accounts to different sales officers...

Okay, I am now officially loosing my mind. I am trying to take my running total formula and use it for a cross tab report. I can see the formula within Crystal, but when I try and put it into a cross tab it does not show up as a field I can use for the cross tab. I do have the formula...

Thanks! I had never done anything with running totals before and there is a lot of great stuff in there! I used the formula and it looks as though it will work like a charm. Have a great weekend!

I am going nuts trying to figure this out and I am hoping someone here can help me. I am using Crytal 8 and am trying to make a report that shows balances in months. I have two years worth of data but I only want to base the average on this year. What I want to do is make a formulas that...

Thanks for all the replies!! I did the custom format and it worked like a charm. You saved me a bunch of work!!

Hi all, I have a spreadsheet with a bunch of numbers. What I would like to do is put in some kind of formula that will divide each number by 1000. The end result would be my dollar amount of $1,000,000 would be $1,000. Which is the format I need for all the numbers in my report. I see that...

The NZ functions worked like a charm!!!! It was much easier doing it that way. Thanks! You made my day!!

Hi all, I am using Access 2000. I am trying to add two fields together in a query. My query looks wrong because it doesn't want to to do the calculation on null values so this is what I have. The two fields are 1. OneTimeFees 2. OngoingFees My calculated field will be TotalFees. Here is...

Why not just do a mail merge. Are you familiar with using mail merge? It is quite simple once it is all set up. Here is a link that will walk you through the process http://computing.fandm.edu/training/wordx/mailmerge.html]tutorial

I didn't even think of that. That will work as a perfect reminder to me to make sure I change the date! I always have a backup of the table just in case something goes wrong, but I would rather be safe than sorry. One of the things I did was make my customer number a primary key and my file...

I made my own query this morning. I just did Filedate: #01/31/2003#. The only thing I need to do is make sure I change the date field the end of each month and then append it to my table. If only everything else in Access could be that simple. :o)