Search results for query: *

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

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...

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...

I am trying to group a field and I get the error message "Cannot group that selection". It was working, then I refreshed the data and now I cannot re-group. Any suggestions? Thanks! Karla

When upsizing my Access 97 database to SQL server - I am getting an "Overflow" message - does anyone know what this means and how to fix it? Because of this message, my tables are not upsizing to the server. Any thoughts or suggestions are much appreciated! Thanks! Karla

I have an NPV spreadsheet where the user fills out financial information associated with a Unique Project ID. Now I need to get the data into Access by providing an uplink button on the Excel spreadsheet. I can go in and convert the excel spreadsheet to an access table, but how can I enable the...

I am trying to pull one field from an Access database to my Excel Spreadsheet. For example: The user enters projects in Access and each project is assigned an ID#, while in the project record, the user needs to go out to an excel file to fill in NPV information. How do I get the project ID...

Does anyone know if you can format the text inside of a message box? In the VBA Code, I have the msgbox declared as strmsgtext = "message to user".... Can I somehow set the text font properties of this string? Any suggestions? Thanks in advance for your help! Karla

I am trying to make a field automatically populate additional fields with the incremental years. For example: if the project start year is 2002, and the project lasts 10 years, how do I get the remaining year fields to automatically populate, 2003, 2004, 2005, etc for one record. Any...

I am working on a portfolio management system in which we have a really involved NPV calculation (3 different worksheets) in Excel to fill out for each project in Access. Not all of the NPV data needs to be seen in Access, only the summary data so we can chart our investments, revenue, etc...

I am trying to email an access report that contains a chart. I have tried exporting it as excel and as html and both times the report header gets through, but the chart does not show up. Any suggestions? Thanks in advance for your help! Karla

I have not had any luck using the bubble charts in Access, so I would like to take the Access table data and chart it with excel. I can export the data to excel and then manually chart it, but how do I automatically get excel to chart my data and show it in the access report? Any suggestions...

I am trying to create a bubble chart which graphs: Complexity as the x-axis NPV Value as the y-axis Total Resources as the size of the bubbles Using the wizard - I cannot seem to get the data in the right order - it always creates a standard (1,2,3,etc) x-axis, then 2 bubble data points and one...