Search results for query: *

Thanks Skip! This might be a remedial question - but how do you filter in a pivot table? Thanks! Karla

Thanks Skip! Great idea - but this would only give me the top 10 customers ranked by margin % and I am looking for the customers representing the top 10% of margin. Any ideas on this one? Thanks again! Karla

Hello all! I have a pivot table where I am sorting and showing the top 10 or bottom 10 customers by their margin. Is there anyway to show those customers in the top 10% and bottom 10% of the total margin? I have a calculated field to show margin as a % of Total, but I can't figure out how to...

Sorry for the remedial question - I'm an access person and just beginning to learn flash. I have a text box: VALUE and I am trying to bend it to fit along one side of a circle. Any ideas? Thanks in advance! Karla

Still the same result.... no sums, just $0 in the totals box.. Thanks! Karla

I set the value of [txtBP] with code, then created text box[ActualBP] and set the control to =[txtBP] and set RunningSum to "Over Group" in the Quarter Header. Now, down in the Corporate Account Footer, where I am trying to get the totals, I created a text box named [TotalBP] and set...

Yes - txtBP is calculating the differences correctly from one quarter to the next. It is visible. It shows the correct sums from one quarter to the next, but is does not show cumulates as you add quarters. i.e. if a quarter shows $0, then the sum shows $0 instead of the total from the previous...

I changed my calculated field to a text box, added running sum Over group to the properties. the grouping structure is as follows: Corporate Account Header Invoice Year Header Quarter Header - this is where the text box is calculated [txtBP] Detail Quarter Footer -...

Worked perfectly! Thanks for your help!

I changed my labels back to text boxes and tried what you guys suggested above, but the sum is not showing up in the footer. The calculation for the text box (calculating the differences) is done in VB in the background, so I am wondering if this is why I can't catch the value to sum it up...

Thanks so much for your help! I tried adding the invisible text box, but I keep getting an error, like it can't read the [lblBP] value. Is this because [lblBP] is a calculated label instead of a text box? I used a label calculation because I needed to show the difference in Base Price across...

I have a label calculation ([lblBP]) to show the difference between two fields. These calculations are performed for each record. Now, how do I calculate the total of all of the calculations [lblBP] over all of the records to put in the group footer? Any ideas would be much appreciated...

When I export my report to snapshot, the snapshot file has my report, but it has been shrunk and now resides in the upper left hand corner of the snapshot files. Any ideas why this is happening? (it doesn't happen for all of my reports, just one or two of them thus far)- How do I get it to...

How do you get rid of the decimal places when using the "Currency" format? Here is the line: lbldifferenceAR.Caption = Format$([SumOfSumOfAR] - LastAR, "Currency") But since it's standard formatting, I get the 0.00 decimals when I want the rounded number without decimals...

Worked perfectly! Thanks for the help!

Ah ha! Thank you so much!

Thank you Norris68 - this worked great! But now, as I try this code for the other fields that I need to calculate, I am getting this error: "The expression OnFormat you entered as the event property setting produced the following error: Ambiguous name detected: Detail_Format" Do I...

Here is the SQL code: SELECT [Field Seller Data Final].* INTO FS_Guajardo IN 'C:\Documents and Settings\u361755\Desktop\TPM Data\TPM Seller Tables.mdb' FROM [Field Seller Data Final] WHERE ((([Field Seller Data Final].[Field Seller Name]) Like "*guajardo*")); Any ideas why this one...

I have make table queries set up to split the database out by seller, so I query on each seller's name. I am setting up all of the queries the exact same way, but for some of the sellers I get "invalid Argument" when trying to run the query. I check the seller's name and it is...

This is probably an easy one, but I'm stuck! I have a report that shows the volume and sales per quarter. I now want to show the difference between quarters to show if sales are increasing or decreasing from the previous quarter, but I can't figure out how to write the expression since there...