Search results for query: *

Very close. I need a formula that will sum the prior one years worth of total sales by month. I need 24 months of these totals so the actual input would be 36 months worth of data. I don't need help with the report just the formula. I'm going to plug it into a Crystal Report. Input...

I guess I'm not explaining myself very well. I want two years worth of rollingnetsales by mm/yy by customer. mm1/yy1 mm2/yy1 mm3/yy1 etc. Customer 1 RollTotNetSale RollTotNetSale RollTotNetSale Customer 2 RollTotNetSale RollTotNetSale RollTotNetSale

It will probably be run at the end of each month, I guess that means thismonth.

I'm not sure what I should call it but it is the total for the prior 365 days for each month. I should have listed net sale and not transaction date. Sorry about that. Martha

I need to calculate a ytd running total of sales by month by customer. That is, for Jan 07, I need a total of sales for 2/1/06 through 1/31/07, for Feb 07, a total of sales for 3/1/2006 through 2/28/07, etc. Here is the layout Apr 2007 May 2007 June 2007 Customer 1...

I gave your solution a try and it works perfectly. Thank you so much.

Thank you!!!I'll try it tomorrow. I'm sorry I didn't supply same code at first. I really didn't know where to start.

I'll try again. Our company sells lab equipment. A customer buys 1 or more pieces of the equipment. They also buy consumables. We want to know at any point in time what is their purchase of consumables per piece of equipment. Each record is per part purchased...

I don't know where to start with this. My goal is to report the consumables sales dollars per equipment installed at a customer. Both are sold by us. Table: customer name, sale date, part number, sale quantity, sales dollar. The part number is used identify equipment vs. consumables. The...

I use Crystal 9. No summary options are offered when a running total is pulled into the summarization section. The crosstab report trends sales to individual customers. There are two groupings of sales (reagent & plates) and a total. Each group has 3 summaries: the running total of number...

This is what is happening. Customer 1 Reagents (Running total of installs) 2 (Total dollars) 2000. (Avg. per installation) 1000. Plates (Running total of installs) 2 (Total dollars)...

Sorry I added this to the wrong thread. It probably doesn't make any sense to you.

This is what is happening. Customer 1 Reagents (Running total of installs) 2 (Total dollars) 2000. (Avg. per installation) 1000. Plates (Running total of installs) 2 (Total dollars)...

I have one more question. In the total section, I need to be able to report just the running total of installations by customer. I can't overcome the fact that it sums the running totals in the sections that come before it. Thanks again. Martha

This works great! I'll be able to use the method in many situations. Thanks so much.

Thank you. I'll try this early next week. Martha

No. I have tried this. The installs are instruments that use the consumables. A customer will have one or more. They may buy one instrument in February and three in June, etc. The consumables are used with the instruments and are ordered as they are needed. We are trying to trend the...

Is this possible? We want to use a crosstab table to report the average purchase of consumables per customer installation. I can use the running total to accumulate the number of installations on site. I would like to divide the total consumable purchase by the running total of installations...

I need some newbie level instructions for signing on to an Access database that is secured at the user level in a shared workgroup .mdw file. The .mdb and .mdw files reside on the same server. What is the code to do this and where do I enter it? Thank you.