Rounding Averages on my Report
I created a summary report using the report wizard and grouped by date and
The report works fine except I would the numbers to be rounded. For example:
The average for January shows 19.5, however I would like it displayed as 20.
If February is 23.1678993, I would like it displayed as 23.
Can someone help me with this? Thx
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
...Secondary axis help
I am having some difficulty in Excel 2007 Charting. I have a stacked
bar chart that I would like to add a horizontal secondary axis on. How
do I do this? I'm trying to do what the Help says but there is
something that I am not getting.
1. I click on the Chart and select the Format Tab
2. In the Current Selection section, there is a Chart Elements drop
down and I select Horizontal (Category) axis.
3. I go to my sheet that has the data for the chart and I select the
data range that I want per the instructions.
I'm lost after this.
well, the Help s...BOB? More Craps Help
Been spending some time on the code you sent and I think I
found some errors. Can you check the code below to see
what you think? I think it is now working according to
the correct rules...
'Excel Craps V1.3
Application.ScreenUpdating = False
Application.ScreenUpdating = True
[B5] = [B2]
If (([B5] = 2) Or ([B5] = 3) Or ([B5] = 12)) Then GoTo
If (([B5] = 7) Or ([B5] = 11)) Then GoTo FirstLucky
cellvalue = 0
...changing a custom toolbar
I have a legacy access database that i'm now working on in Access
2007. I have a custom toolbar set up in there (at least that is what
A2007 shows it as on the Add-Ins tab of the ribbon). I need to edit
that custom toolbar (menu). How do I do that?
I have spent a lot of time trying to find examples to be able to edit a menubar from a previous version in Access 2007.
Finally, I have come up with the following that works! I hope this helps:
--- start code ---
Dim cbr As CommandBar
Dim cbrctl As CommandBarControl
Dim cbrbutt As C...SQL General Help
I have been experimenting with using ADO to work with Excel data. I had some
obstacles with the SQL until I stumbled across a web site that mentioned the
table name needed a special format. Instead of using a table name like DATA,
instead I had to use the format of [DATA$].
So I was wondering does anybody know of a source (document, web site, etc.)
that explains all of the peculiarities of using SQL with Excel?
...Employee Training Help
I am creating an employee training database where I can run reports and
queries about who has taken what type of course.
What kind of relationship should be created between the tables? Based on the
some of the discussions I have seen here, I have created three tables:
1: tblemployee (with employee id set as primary key)
2: tbltraining (with trainingid set as primary key).This table has no
3: tlbcompletedtraining (in this table I have employee ids with the id's of
the training courses that they have completed)
I am unsure of what ki...Need Help with Formula #3
I need help trying to come up with a formula for a friend
of mine. This is what he wants -- Using any 9 numbers --
he wants Excel to come up with every possible 3-digit
combination of numbers that are divisible by 7.
Is there anyone who could assist me with a formula that
will perform this calculation? Can Excel do such a
Thanks so much for any assistance you can offer.
In A1, enter the number 7.
Edit>Fill>Series, Step value 7. Format>Cells>Custom, "000".
If with "using any 9 numbers" you mean you don't want any zero...SUMIFS help
Hi. Hope you’re able to help. I’m having difficulties the SUMIFS function.
Either I’m using it incorrectly or perhaps it’s the wrong function for me!
I’m trying to total the money amounts in column E as long as conditions in
columns A (cell A6 in this example) and column H are True. However, I’m
finding that the function is not totalling up the money amounts it should be
totalling in column E. Instead, it’s just returning a single money amount in
column E and ignoring the rest! This is the function as I’ve written it:
=SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!...newbie needs help
First to let you all know, I am a big novice at this kind of stuff, so
please bear with me.
What I am trying to do is make a trendchart with 9 different plots on it.
How do I change the numbers on the side and bottom of the chart to read what
I need them to? I take these tests 3 times a week and would like to chart all
of them seperately and also together to chart progress for a whole month.
One for each day, and then one for the month. Then I would like to do the
same for the following months of the year. And I would like to have one chart
to show the progress for the whole...Need to truncate a transaction log
I have a database which is 2 GB but the log file has grown to 35 GB. I would
like to truncate the log so I set the recovery method to SIMPLE but the log
file did not truncate after last night's backup.
This has worked for other databases and I get a small log file. Later, I
reset the recovery method back to FULL.
Rich Lawson (email@example.com) writes:
> I have a database which is 2 GB but the log file has grown to 35 GB. I
> would like to truncate the log so I set the recovery method to SIMPLE
> but the log file did not truncate after last night&...Latest Exchange Administrator Needed admin.exe = 5.5.2655.33
If any body knows were to download the Exchange Admin (admin.exe Version 5.5.2655.33). I am having a problem with mailbox sizes being incorrectly diplayed in Exchange admin. I have dozens of Executives that have mailboxes over 4 or 5 GB and I have no way of correctly reporting there sizes other than using ExMerge. Please help.....
You will need to call into our Tech Support and refer to the following
Knowledge Base article and tell them that you need the hotfix.
305829 XADM: Incorrect Mailbox Size Is Displayed in Exchange Server
Thanks,...I need to write this formula in basic
Does anyone know how to write this formula in Basic. I need to make it
work in Openoffice because Excel seems to crash with a list of 20000
...Chart Type HELP!
Hi, I still need help on the Chart Type thread that I posted a couple of
hours ago under "Chart Type".
It is URGENT--for a presentation for which I am already late!!
Hi Sat - Take a look at what I just posted and see if it helps.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------...Problems with Crystal Reports
We are currently encountering a problem with Crystal Reports on MSCRM.
Launching one takes about 10-15 seconds before data is displayed (even if
only 1 record is retrieved). The standard Accounts reports are worse, we
get a Timed Out error everytime.
We are deploying MSCRM on 2 servers - CRM Server has dual procs and 1GB RAM.
Any suggestions are very much appreciated. Thanks in advance.
Having Crystal reports in CRM 1.0 timeout is a known
bug. (Happens after you try to retrieve more than about
10K records.) There is a private hotfix. It will also
be fi...(?) Free credit report and monitoring from Experian?
How do I get the free "credit report and monitoring from Experian" offered
with Money Deluxe 2004? When I click, I'm sent to
https://msmoney.creditexpert.com/CE_site/MCCLogin_C.aspx , but I see
no-where to create a new account.
Queries to firstname.lastname@example.org have not been answered.
Do a little search at the Consumer Reports site and you will find the
addresses and email addresses of the 3 credit reporting agencies. I
believe they are required to send you a free report once per-year.
You can research the referenced CR reports at your local libra...FRx Report Date won't change
We have a customer that has a GP Fiscal Year of 9073. Apparently, an AP
transaction had accidentally been posted with a document date of 9073. So,
in order to void that transaction, they created the fiscal year of 9073.
Now, in FRx when they try to change the Report Date to December 2008, FRx
changes the report date to December 9072.
We've tried deleting the .g32 file and rebuilding the FRx GL Index. We've
also tried deleting the SY40100 and SY40101 tables, rebuilding the Fiscal
Periods in GP then rebuilding the FRx GL index but we still can use the
12/2008 date in FRx.
Any...Cannot add customer statement email address in Smartlist
On the Debtor Maintenance Options screen you can chose the checkbox to Send
Email Statements to a customer and then enter the To, CC or BCC email
In Smartlist under the Customer folder, while you can choose to add the Send
Email Statements column you cannot select to add the To, CC or BCC email
address fields. You should be able to do this so you can easily view the
These columns should be standard columns that you can select for Customers.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most vo...Help with formula containing text
I need some help on the following.
I have a column of text, linked to other worksheets, that is
continuously changing. I need to be alert if the same piece of text
appears in the column more than twice, e.g.
mlhynes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12959
View this thread: http://www.excelforum.com/showthread.php?threadid=401787
Visit Chip Pearson's site for much help on duplicates.
Fin...Rota's and Daily Shift Pattern's
I've got a basic rota sheet with Mon-Sunday along the top and the names of
the staff down the side.
Each day a memember of staff is either AM, PM or OFF.
I'me trying to create a sheet that just has monday at the top with all th AM
people on it. Then a sheet with all the PM people on it.
Thanks in advance
is this just for printing out? if so i would use the autofilter (data /
filter / autofilter) - choose the drop down for MONDAY, choose AM print
results ... choose PM, print results ....
"Scott Cheesman" <Scott Che...Help with combining 2 seperate Worksheet Change Event scripts
I have 2 seperate Worksheet Change Event scripts that I would like to
combine to use in one woeksheet and I'm sure how to do. I am kind of new to
The first script is for hiding columns based on a value selected in picklist.
Private Sub Worksheet_Change(ByVal Target As Range) 'SalesAid Software
If Target.Address <> Range("L2").Address Then Exit Sub
If Target = "All" Then
Range("N:BV").EntireColumn.Hidden = False
lastcol = Cells(6, Columns.Count).End(xlToLe...Report WRITER legends values #2
I need to modify existing modified report. Where can I find values for
Hello Sofiya, Legend fields are placeholders that may contain pretty much
anything, depending of the report you are working with.
For example, on many reports, they are used to display the range values used
when generating the report. (From-To)
One thing you must remember though is that they are always typed as strings
so you need to convert them if you want to do any arithmetic operations with
In conclusion, if you want to evaluate the legend field values for a report,...Excel reporting alternatives
I am part of a team currently looking for alternatives to replace Vision XL
which our Finance team uses for ad-hoc reporting in Great Plains version 8.
Although I am still seeking clarification I believe that Vision XL will not
work with GP 10 or Office 2007 which we will soon be upgrading too hence a
need for a replacement. My team will be writing sql reports using visual
studio etc but our Finance team are rather hoping that they can continue
using some kind of excel reporting tool, any ideas would be most hopeful.
One of the benfits of ...Tools.Customize.Commands.Modify Selection (doesn't)
I have a macro (I wrote) that is listed with the project name (and the
project name appears on my button) and despite following (what I believe
are) the instructions for renaming it the "Modify Selection" button in the
Tools.Customize.Commands dialog box is never enabled and I can't rename it.
It's Outlook 2000 if that matters.
...Need Help #2
I have created a custom button for Tag along item.and I am having problem
with cursor box. It is not moving down. It is staying where the tag along
item rang up.
It should move down to empty line, But It is not. How Can I fix his problem.
Any one can help me ?
...Help with transforming file
I want to transform html tags with in the xml file when it use the asp:xml
tag, how would I do this?
Here is the example of the xslt file:
<?xml version="1.0" ?>
<xsl:output method="xml" indent="yes" encoding="UTF-8"/>
<table width="75%" align="center">