Search results for query: *

I am trying to format a chart where the data axis is a dollar amount that ranges from the $100K's into the $1M's. However when I try to format the axis using the 'number format' within the chart expert, when the number goes beyond the number $999K and hits a million - the number format remains...

Actually to change the rotation of objects and such, you need to first click on the chart so it is selected, right click and select 'Chart Analyzer', from there, select the item you want rotated (a box will appear around it), right click and go to 'Format Chart' then to 'Selected Item'.

I want to average the order amount for the month (# orders for month / total sale amt. = avg. order amount)and have those displayed in the detail section of the crosstab. But since the calculations are performed prior to viewing the crosstab, I don't know what to do at this point. I would...

I am trying to calculate a monthly average of sales based on territories within a cross tab. Does anyone have any idea how to do this? I have tried the simple fix of changing the summary from sum to average, but the numbers are totally off. Below is an example... 2/2002...

I am looking for a rebar code within VB that uses ActiveX for someone I work with. Unfortunately I am not extremely familiar with the term 'rebar' all I know is it is somewhat of a toolbar that can be used like an explorer toolbar I was told that something that uses ActiveX.dll would be more...

Does anyone have working code for rebar?

I tried it anyway prior to getting your next post. The highlighting expert will not work with date fields, only number and currency. I tried everything. Any suggestions as far as the else if boolean requirement? I had that one somewhat working, but it was bass-ackwards, doing exactly the...

Now I am asked for a boolean between the else if

I used the above formula, works wonderfully. However, I am working with a DateValue field and when I ask it to change any records that are < 2002,03,01 it doesn't change the background color. It only effects those fields that have data in them. I need something to change 'Null' value fields...