TempVars unusable in field default value
I'm trying to use a temporary variable to keep track of which CSR is
I have a macro which prompts user for ID code, which is stored in the temp
On a form control default value property, I can use the expression
[TempVars]![TempUser], which will populate that user's ID code into the
However, I cannot use that same expression in the tables field default value
property. If I try, when I save the changes to the table, I get the error
message "Could not find the field 'TempVars]![TempUser'. "
Any ideas why I ca...rounding up values
Has anyone done round up of values to the nearest dollar.For example I want to give a 10% of the price to my customers but if the result is other than .00 then I wanted to round up to the nearest dollar amount.My calculation using sql has been price * percent and then subtract the value from the price, then what do I need to do to roundit up??Thanks for your suggestion.Also I have a problem with my customers that I am extracting and the query does return all the values from 2004 and 2006 that are equal except for the price I have given them, how do I get only the latest ones in 2006 and not th...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Add rows automatically? Accordion
Is there a way to automatically add/show rows that have data?
I have a data entry sheet. Then I have a report.
The report pulls data from the entry sheet.
If there is no data for a specific line/row item, is there a way to
automatically hide or not show the row(s) with no data?
can I have more than one autofilter on a sheet?
> Use the filter function
> Select the data and click on...
> This should make an arrow appear at the top of the data (in the header row).
> click the arror and select "Nonblanks"....Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...TaxFree add-on
Somebody have an add-on for taxfree print? I need a demo to submit to
customer that use rms 1.3
...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...Multivalue with Null value SSRS 2005
I have a query to populate a multivalue parameter:
SELECT distinct cast(AGRPYear.value as varchar(4)) + AGRPMonth.value
FROM TPROJECT AS TPROJECT
One of the values that is returned from this query is NULL. However, when I
run the report, the NULL value does not show in the dropdown. I've also
"select NULL as 'ReportDate' union" to the above query and the null value
still doesn't show.
As a result some of the records in my database have a null value for this
field, they will never show up on my report. Any id...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Status Bar #4
Hi - can anyone tell me what the "official" name is for the facility on the
Excel Status Bar which allows you to select a range of cells and view the
Sum, Average etc of those cells?
It's the AutoCalculate feature:
AutoCalculate feature is working even if that feature is turned off
XL7: CTRL+Click Selected Cell Changes AutoCalculate Value
> Hi - can anyone tell me what the "official" name is for the facility on the
> Excel St...how to run onhand value report
I get the message enter parameter when entering the zoom feature
On Sat, 6 Mar 2010 17:36:01 -0800, junebugg
>I get the message enter parameter when entering the zoom feature
You'll have to give us some more context than that, junebugg. What's the
"onhand value report"? What's the "zoom feature"?
You can see your database; we cannot!
John W. Vinson [MVP]
...how to view the stack when there is a messagebox in front
Have anyone tried breaking the execution when there is a messagebox popped
up my the
::MessageBox(....) function or AfxMsgbox(...)
The call stack just shows
Is there any easy way to see the call stack at this point.?
Install the symbols for the OS files ( like user32.dll, kernel32.dll
Check Abdoul [ VC++ MVP ]
"Fleming" <firstname.lastname@example.org> wrote in message
> Have anyone tried breaking the execution when t...Increasing and decreasing values
Using column chart type I want to display increasing values and then
decreasing values (not negative). For example 10,20,25 top value 55, then I
want to show from 55 decrasing amount 10,35,10 (back to 0 starting point). Is
Put the numbers into the worksheet. A row or a column, whatever you like. If each
number has a corresponding category label, put them in the row or column before the
data. Select the data (one or two rows/columns), and run the Chart Wizard (the icon
like a column chart, or Insert menu > Chart). Choose the Column chart type, and
click through the rest o...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...Textbox fomatting value based on another textbox
I have two text boxes on a form. One is a value that can be changed by the
user. The second is the value 1 - textbox1. I need everthing to be in %.
For example, in textbox1 the user could type 75 and it would automatically
be recognized as 75% and textbox2's value would calculate to be 25%.
Everytime I try textbox1's value is = to say 7500%. Any help is
Maybe something like:
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim TB1Val As Double
If IsNumeric(.Value) Then
TB1Va...Formula to count the number of different values in a range
I'm looking for a formula that will give me the number of different values
in a range.
Example: Column A may have five cells that are "4", five cells that are
"7", five cells that are "9". Of the fifteen cells that contain data, there
are only 3 different values. I'd like to use a formula that will count the
number of different values in column A, in this case the result is "3".
How can a cell in one workbook be linked to data in another workbook.
try the following:
- open both workbooks
- in the target workbook enter the equatrion sign '='
- now select with your mouse the source cell in the other workbook and
"Kenneth" <email@example.com> schrieb im Newsbeitrag
> How can a cell in one workbook be linked to data in another workbook.
Or copy the source cell, select the target cell, choose Paste Special
from the Ed...Add a secondary administration group error c1041721
I have added a new administration group for a sub site in Japan and now I am
getting the following error:
The action could not be completed because the Microsoft Exchange Information
Store service is unavailable.
Operation: Retrieving mount information
ID no: c1041721
Exchange Sytem Manger
I get this error when I try and drill down to the new admin group to the
First Storage Group. I only get this message on machines on my side of the
network. If I remote to the mail server in the new site I am able to drill
all the way down and see the mailboxes. I can also see our main site
informat...How do I add third-party templates to Visio
I downloaded a new template library and am trying to figure out how to add
it to the Software category (I think), however the info on how to do this
seems a bit sparse.
There appear to be two types with this library that do the same thing when I
click on them -- *.vsd and *.vst.
Does anyone know what I need to do to add the library?
On Mon, 12 Mar 2007 13:43:48 -0700, "Tom Jones" <firstname.lastname@example.org>
>I downloaded a new template library and am trying to figure out how to add
>it to the Software category (I think), however the info on how to do this
>seems a b...Unassigned value in split transactions in conversion from Quicken 2001 to Microsoft Money v 14
With Quicken withdrawing from the UK market I have taken the plunge and
upgraded to MM v 14.
There is a serious conversion issue with the processing of split
transactions where the first entry is converted correctly but all the other
lines from the split transaction generate "empty" split entries each with a
blank category and description with a zero value.
This leaves an unassigned value equal to the sum of the ignored split
I have two Quicken accounts my private accounts going back to 1987 which
generated a vast number of these unassigned amounts in split transactions
a...Errror Help: character ' ', hexadecimal value 0x2 is illegal in xml documents
what does this error mean? how can i fix this?
* raj wrote in microsoft.public.dotnet.xml:
>what does this error mean? how can i fix this?
You have an octet 0x02 or perhaps a character reference  in the
document. This is not allowed in XML 1.0; the latter is allowed in XML
1.1 but your version of the .NET framework probably does not support
that, and most likely you have not declared this version either. In
other words, your document includes random binary data and is there-
fore not an XML document. You have to correct the document before you