Max Customers Accounts in CRM 1.2
One of our client who is evaluating CRM asked for number of Customer
Accounts Limit of MS CRM 1.2. We know that MS is targeting CRM for small and
Medium size orgainzation but can it support customers of an orgainzation to
Can some one tell the max limit of Customer Accounts. ?
There is no defined maximum.. The key is sizing the SQL server appropriately.
Especialyl with CRM not supporting clustered SQL servers.
I know there are companies out there that have implemented (or are in the
process of implementing) installs for > 1,000 users.
MVP - Micr...Pub 2000: insert Unicode by number
I wish to insert a couple of Unicode characters which do not appear i
Publisher 2000's symbol list. Is this possible
Andrew Bryant's Profile: http://www.officehelp.in/member.php?userid=511
View this thread: http://www.officehelp.in/showthread.php?t=126125
Posted from - http://www.officehelp.i
Andrew Bryant wrote:
> I wish to insert a couple of Unicode characters which do not appear in
> Publisher 2000's symbol list. Is this possible?
Try (with NumLock on) Alt+(Uxxxx), where xxxx is...auto number a word document each time it is opened
I would like to know how to have a number update automatically each time the
document is opened. I have tried all the avenues I know and still have had no
I am using word 2003 and have no experience with macros, however I am keen
to learn. I am struggling to get the below advice to previous users "
to work for me. It keeps coming up with error messages after I have created
the macro, the main one being "Compile Error: Expected Function or variable"
for the "Order =" and then...Excel formula divide list of #s by N to get a number above 40
I have a list of numbers. I need to divide each of those numbers by the same
number ("N") that will give me a resulting list in which all of the numbers
are at least 40 or above. Is there a formula that will find such a number?
"JudyK" <JudyK@discussions.microsoft.com> wrote in message
> I have a list of numbers. I need to divide each of those numbers by the
> number ("N") that will give me a resulting list in which all of the
> are at l...numbers in a cell change
When I type numeric numbers in a cell they change to a type of formula when I
exit the cell. How do I get them to stay numeric only?
I just can't picture what you're describing.
Could you post some examples?
Please keep all correspondence within the Group, so all may benefit !
"GeorgeA" <GeorgeA@discussions.microsoft.com> wrote in message
news:...Export number without decimals
When I export my data from a query in csv format, one of the fields which
has 13 digit numbers diplays decimal places when infact the data in the
database does not have any decimals.
How can I force this field in my query to format with zero decimals so it
currently doing 1310010010011.00
want to show 1310010010011
It might be a bit of a kludge, but you could convert the number to text
(CStr()) in a query before exporting the query.
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/...Formatting Page Numbers
I am formatting a manual that supposed to have page numbers starting 0.0,
0.1, ... then 1.1, 1.2, 1.3, etc. with an accompanying TOC.
I am perfectly willing to put the page numbers in manually to make sure that
they are done accurately, but I cannot figure out how to turn off the
automatic page numbers or format them the way I need to. There must be
something I can do with section breaks, but the revision date is alternating
vertically on the side of the pages because it's a manual.
Thoughts on how I can make the page numbers work out?
What dictates the change from the ...Max and min
I would like a formula to anticipate the expected maximum and minimum of
votes for each political group in the elections and that the variables are
necessary to know
Thanks in advance.
...Adding a version number to a document
Is it possible to add a version number to a workbook on saving and closing
Yes it is possible. You can manually change the name of the document, e.g.
from Draftv1.xls to Draftv1.1.xls.
Or else, you can use a macro to increment your version number every time you
firstname.lastname@example.org_2nd_at. Randburg, Gauteng, South Africa
> Is it possible to add a version number to a workbook on saving and closing
Good afternoon Tigsboy
You will need a macro to do this for you, but just to put you on th
Private Sub Workbo...How can I display negative numbers in a floating bar graph?
I have two categories where the minimum value is a negative number. When
Excel graphs these two categories, it starts at zero, rather than the
negative number. I can't figure out how to get Excel to display the numbers
Keeping in mind that a floating chart is a stacked chart, follow the procedures on this page:
In short, the bars cannot cross the axis, so you need two series, one for the positive part of a
bar, and another for the negative part.
Jon Peltier, Microsoft Excel MVP
Pelti...maximum number of recipients
I am using Microsofts Outlook 2007. What is the maximum number of recipients
that can be added to send one message to? I get an error code 452 when I
want to send one message to a few recipients simultaniously.
Which is an error code and limitation set by your ISP and is not coming from
Outlook. You'll have to contact your ISP to find out which limit applies to
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real ...find header then replace header with number of entries below heade
I have a data set that contains over 66,000 lines. I would like to search for
each 'nan nan' then replace it with the number of entries that follow until
the next 'nan nan'. Ex. the first 'nan nan' to be replaced with '7', second
with '17'. I would also like to enter a '1' in the cell to the right of each
Thanks in advance. Kevin
-89.424686 28.9232...Does Smartlist have max # of records it looks at?
I created a report through SmartList builder and when I run it, the
information stops at 12/7/09. It does not show the rest of the year
regardless of what date criteria I use. I then created a similar SQL query
and made a new SmartList from that query. Again the information stops at
12/7/09. Is there a maximum number of records that SmartList will look at?
Or any ideas on why this is happening?
This is my SQL query:
select a.ordocnum, a. crdtamnt, a.debitamt, a.trxdate, a.actindx,
a.ormstrid, a.ormstrnm, a.dscriptn, b.mnacsgmt, c.userdef1, c.userdef2
from gl20000 a lef...Hindi Number Format
Is ther an equivalent in Access for a for a number format available inExcel .NumberFormat = "[$-2000000]#0,000.00"so that I can have Hindi numerals in a reports.when I use Numeral shapes to context or system or National it is notgiving me the desired result.How I can apply this in a Report so that the field will be formatedusing the above way?Thanks...Formula For Sorting Part Numbers
I have Excel 2000.
Sheet1 of my workbook has:
* Part numbers in column D
* Primary bin location in column F
* Secondary bin location(s), if any, in columns I, J, K, L
* Each part number and corresponding bin location(s) are listed on the same
row and there are no duplicate part numbers
I need help with a formula (to be inserted in Sheet2) that does the
* List all the part numbers and bin locations (primary + secondary) if there
is an "X" in column AB of any part number listed in Sheet1
* All the information for a part number should be on a single row
* T...Total number?
hi, I want to display a total number for all the number in series, how to do
that? please advice. thanks.
What is 'number in serias'?
<email@example.com> wrote in message
> hi, I want to display a total number for all the number in series, how to
> that? please advice. thanks.
Sum() all number but only the group/category. How to do that?
"Uri Dimant" <firstname.lastname@example.org> wrote in message
> What is 'num...Add hyphens to a number
In one column, each cell has a 16 digit number. I need to put hyphens
between 4 different numbers in each cell. Each cell/number will have
the hyphen in the same place. I was successful doing this once I
believe through Format\Cells\Number\Custom but I did not write down the
steps how to do it.
texasphil's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32615
View this thread: http://www.excelforum.com/showthread.php?threadid=541305
I am looking for a query that will return all the entries where a certain
field has its max value.
I am interested in all the values where version is at its MAX for a certain id
if my table is:
id idea status version
1 Apple open 1
1 Banana close 2
2 Chair close 1
3 Table open 3
3 Flower open 4
4 Keyboard open 1
I would expect to get:
1 Banana close 2
2 Chair close 1
3 Flower open 4
4 Keyboard open 1
Create a query that selects the id and max(version)
Create a second query that joins the table...Transfer Out Serial Number Issue
I'm working on setting up RMS for a store. We have many items with serial
numbers that we wish to be able to track. We sell many of the items retail
but also use them internally to build assemblies that we sell. I have the
database set up with the items and have serial numbers entered for the items.
We are trying to use Inventory Transfer Out to take the serial items out of
inventory for our assemblies and then Transfer In the completed assemblies.
I am seeing a problem with the serial numbers when issuing and committing
the items. Transfer Out doen't appear to check the...average a row of numbers?
I am trying to get the average of a row of numbers with various numbers of
columns. I have 50 rows of numbers and am looking for the formula to average
all of the rows, showing the average of each row. I know how to do them
individually, but very time consuming. Any help would be appeciated.
Insert a column and enter =AVERAGE(B1:IV1)
Copy down 50 rows.
Gord Dibben MS Excel MVP
On Mon, 6 Aug 2007 16:56:01 -0700, wannabe68
>I am trying to get the average of a row of numbers with various numbers of
>columns. I have 50 rows ...ability to configure wait object condition with max wait time capp
configuring wait for object condition results in a wf instance that may wait
indefinitely long. It would be good if we could cap the wait period at a
specified perod of time or object status change.
wait for case.priority = high (abort wf instance after 6 months of waiting)
wait for case.priority = high (abort wf instance after case.status =
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do n...Sorting numbers doesn't work correctly
I rarely use Excel, but I need to sort a spreadsheet in which one of the
columns has only numbers. For example: 121.593, 121.58, 121.641, 121.61. My
expectation was that Sort Ascending would produce 121.58, 121.61, 121.593,
121.641. Instead, the sort produces the following sequence: 121.58, 121.593,
121.61, 121.641. In other words, it doesn't seem to understand that the
two-digit numbers (after the point (.)) go before the three digit numbers. Is
there a workaround?
I don't think I understand..
why would 121.61 go before 121.593 if you were sorting ascending..
-...Maximum number of data series
Maximum number of data series is 255 in Excel. I am using
Is there a way to go around that? I have more than 255
series and I want them to be on one graph?
It maybe possible to work round it but it would require more information
about your data and what you are trying to graph.
> Maximum number of data series is 255 in Excel. I am using
> Excel 97.
> Is there a way to go around that? I have more than 255
> series and I want them to be on one graph?
...Max decimal places
Does MS Excel have a maximum number decimal places. I know that I can format
up to 30 decimal places. (This is not a formatting question.) Is 30 the
default or are the decimal places infinite?
I am uploading a file to a database and want to set the field length on the
database to the maximum possible decimal places as long as its not infinite.
Excel only supports 15 significant digits. Anything beyond that
is no mans land.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"SusieQ" <SusieQ@discussions.microsoft...Numbers won't right-align
I have a fairly simple spreadsheet with 30-40 calculatrions.
Some of the results appear to have a space on the right hand end. Most
of these are calculations, but some are literal numbers. Some are
formatted as currency and some as numbers.
The right justify button doesn't help.
I have checked all of the formatting parameters I can think of.
Can anyone suggest what is going on here?
CURRENCY format places a slight indent on the right hand end of a
number. The NUMBER format does the same thing. GENERAL format shoves
the number hard up against the right hand end, but it ...