Search results for query: *

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)

I am still confused. I tried to build this into my query. Under Properties, Build SELECT [CritOblgBal], #1/31/03# AS Date FROM [CritOblgBal] I keep getting an error telling me that the syntax of the subquery was incorrect. It then says to check the subquery's syntax and and enclose the...

Hi all, I will try and explain this as best I can so bear with me. I have a database I am creating. I have to create this database that shows monthly acitivity on our clients. Each month I get an Excel spreadsheet data dump that shows activity of our clients. It does not keep any other prior...

I remade the report and now all is working fine. Thanks for the formula for the "0 Values" and for the info about Crystal and hot fixes. I may need some of those for future reference the way things have been going lately. :o)

The Dr. Watson error is only happening w/ this one report. I can't access it from another machine because the only machine that has Crystal besides mine is my laptop which is getting upgraded so I don't have it here. I did the process of elimination where I deleted each formula to see if it...

I am getting "crw32.exe" Exception: Access Violation I am going to tweak my formulas and see it this helps. Thanks