Recent content by jdaily

I have a script, see code below, that gets the variables from a program that the script is run from. The variable MARKET contains an array of market names (5 to be exact). The first two steps in the script work perfect but when I get to the for loop it starts working great on the first pass...

Sahmartin, 1. You will need to add the third summary field into the Crosstab's Summarized Field area. I don't remember exactly how the 8.5 crosstab expert is setup so please forgive me if I'm wrong. 2. Once you close out the crosstab expert then you will right click on that summary field in...

For my inner cells I am pulling in the following data: Maximum(clmreq_interest_amt) and {@Total}. I have been able to combine Maximum(clmreq_interest_amt) with the field {@Total} through the formulas you provided in this thread to come up with a combined inner cell. The value is either going...

I see now! One last question. How do I sum on maximum(interest_pmt)? Thank you for all of your help! John

I have the detail totals working correctly per the formulas that you posted above. My only problem is that I can't do a summary total by Check# and a final summary total by State in the Crosstab. I have two summarized fields that are coming into the crosstab. Maximum(clmreq_interest_amt)...

Using CR XI and Windows XP Pro. lbass I have a question about your formula above. I was able to use this somewhat successfully when adding two fields in a crosstab together. I have one summary column with two summary fields in my crosstab. Maximum(Interest_Amt) Sum(Total_Pmts) (If there is an...

PHV, My problem is that I don't see any package wizard for access or office developer extensions, nothing! Do you think it's installed incorrectly or something? I just downloaded the Visual Studio Orcas Beta and it's supposed to have this stuff, and it does for everything BUT Access. How do...

I ran into the same issue and here is what I have used to take care of it. I placed this in my application's start-up form on the Form_Open event. Application.CommandBars.DisableAskAQuestionDropdown = True

That's the problem. I can't find nor get the packaging wizard to work. Are you talking about the packaging wizard in Visual Studio 2005? From what I read I need the Tools for Office also. Is there a packaging wizard in Access? Thanks!

Thanks! I am going to have to purchase that. Do you know where I can find decent instructions for creating a runtime copy of my db? I don't know if I'm supposed to have some sort of add-in or what. I can't find anything that tells me how to make a runtime copy. Thanks.

Running XP Pro with Access 2003 Where can I get the Access 2003 Developer Extensions? I have searched all over Microsoft's website for answers to creating a runtime version of my db but I can't find anything with instructions. Does anyone have anything that's straightforward in creating a...

synapse you're awesome! Thank you for your help! The formula worked like a charm. I had created a formula that took the {date_sent} and created a quarter out of it that gave the quarter and year concatenated. I took your formula and put it in my record selection and it gave me the exact...

You are probably right in that I wasn't very clear in my requirements. I have a crosstab that has {clm.quarter} as a column and {prod.product} as the row. Then I have a total formula that gives the total dollar amount based. The only problem is that I need the data in period that were paid...

Madawc thank you for your help! I tried it but it gave me all of the previous quarters. I only need the previous 4 full quarters. Any suggestions? Thanks, John

Hi all! I'm using CR10 with an Oracle db. I'm havning a problem figuring out how to get this done. I am trying to pull a small amount of data that looks in the previous 4 rolling quarters, excluding the current quarter. I only need the previous 4 full quarters data, no partial quarters. The...