How to enable Custom text, date and number in POS 2009
How do I enabel Csotom Text, Date and Number in POS 2009?
This is a multi-part message in MIME format.
The steps a fairly easy:
1.. In manager view, go to Settings -> Store Settings -> Options
2.. Click on the Customer entry in the list
3.. Then under the Custom field section, you have to add a caption to =
those fields you want enabled.
Then when you go back to edit a customer, you will be able to inp...number format keeps dividing by 100
I've been using Excel 2000 to a limited extent for about 2 months on a
Win XP machine. But the spreadsheets have recently begun behaving
peculiarly.. Whether I'm writing to a completely new sheet or amending
an existing one.
If I type 1 it displays in the cell as 0 and in the edit box as 0.01
If I type 10 it displays in the cell as 0 and in the edit box as 0.1
If I type 100 it displays in the cell as 1 and in the edit box as 1
If I type 1000 it displays in the cell as 10 and in the edit box as 10
However, if I put the cursor in the edit box in the 4th example above,
the 10 is imme...Crosstab Query to produce a report with row field with multiple s.
I'm trying to mimic an excell spreadsheet type summary report with a crosstab
query that has a project number in the first row, SumBudgeted Rev,
SumProjected Rev, SumActual Rev in the second row that belong to that project
number and the Columns are Dates in "mm-yyyy" format. The value field is
Actual Rev minus Budgeted Rev divided by Budgeted Rev. The object is to show
monthly totals of revenues per project number with a calculated column at the
very end in percent. Sorry about the display name all of the good ones are
There is a solution for a monthly crosstab...How can I get a report on the number of field changes made in Exce
I need to be able to account for the number of field changes made in a given
month in an Excel database. Is there a way this can be accomplished?
Possibly keep some record using the change event
Chip Pearson's page on events.
"j.sjoberg" <email@example.com> wrote in message
> I need to be able to account for the number of field changes made in a
> month in an Excel database. Is there a way this can be accomplished?
...Changing tracking Number
Is there any way to change the tracking number after the transaction has
been tendered and marked as Shipped?
...Convert to Number
I appologize for the re-post, I should have put this here originally...
I'm filling an excel (2003) worksheet using the 'Excel Files' DSN through
ODBC. I can get the data into the spread sheet no problem, but some of the
data cells have the little green info triangle that says 'The number in this
cell is formatted as text...'. When this happens, the formats I applied to
the column (currency, percent, etc) don't work.
I've made sure there are no extra characters during the input, I've used
Val() and CDbl() during the input, and I've tried a couple other o...replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER
I am importing basketball stats from another site. No problem until I import
the Free Throws Made/Free Throws Attempted stats. Here each cell contains
two numbers separated by a dash ... for example: 17-24 indicating 17
successful free throws were made out of 24 attempts. Since future
computations involve using only the Free Throws Attempted number, I am
interested in importing only the second number. What process must I go
through to accomplish that? Obviously I am new to Excell and will be most
appreciative of any assistance you can give me.
This formula will strip it out
=RIG...Page numbering delay
I am putting a booklet together, and would like to start
page numbering on about the 6th page. (The first page is
the title page, then a blank page, then the table of
contents, etc.) Can anyone help me with this?
Which version of Publisher are you using?
JoAnn Paules - MVP Microsoft Publisher
"Valerie" <firstname.lastname@example.org> wrote in message
> I am putting a booklet together, and would like to start
> page numbering on about the 6th page. (The first page is
> the title page, t...LDAP Query Builder?
Are there interface tools to help build LDAP queries? Google is not
forthcoming with them.
"Dogs may have kept us company on the hunt, but it was the cats who insisted
we invent houses and discover fire." -- Khiem Tran
...single item number into multiple bins
Hello, we are trying to use RMS to track inventory for an air-conditioning
company with 10 service vehicles, the problem that I am having is for example
if I want to show 5 rolls of duct tape per truck, RMS only seems to allow for
only on bin location per Item number. As I don’t know of any business that
can properly control inventory without the ability to store merchandise in
multiple bins there must be a solution, does any one know how to place a
single item number into multiple bins?
Well, I think that you are going to run into issues because you are
trying to use a retail inventor...Looking to do a random sort of records in an excel file
I have an excel file with records in it. At any given time I can hav
any number of records in the file. I would like to do a random sort o
those records putting the results in another sheet within the sam
excel spreadsheet. It would be nice if the output had a column wit
the ranking of each record in it.
It can't be anything too complicated or something I have to change eac
time I want to do a different group of records. There can be as man
as 200 and as few as 5 records in a file
Message posted from http://www.ExcelForum.com
You could put =RAND() in a helper column and ...Random Numbers not Random
When I create random numbers for an application with the following code, they
do not appear to be truely random.
Me.RandomNumber = Int(9 * Rnd + 1) ' Random Number 1-9
If I have two users setting side by side, they frequently get the same
results when they start up
Am I missing somthing?
Any help would be appreciated
Have you tried a
statement just before the RND?
That should do it.
Microsoft Access MVP
"Find a job tha...absolute numbers from formulas
I need to be able to apply a macro to cells containing numeric values of a
formula, but need the values to be identified in the cell as just numbers,
not the results of a calculation. I.E. macro needs to "see" values 1,2 3,
etc. NOT =SUM(d2:f2), etc. when it looks at the specific cells. How can I
convert these formula calcs into just plain old numbers?
The results of a calculation *are* numbers, so I'm not sure what
you're getting at.
You can use the .Value property of a cell:
and if the cell has a form...Adding activity ID number
I would to add ID number to each activity that is open, like a case number.
This number should be managed by CRM.
I have CRM VER 3.
You can do this using Settings and either using an existing field or adding
Anne Stanton, MVP-CRM, MBA/ACC
The Norwich Group
"Eran Arkush" <EranArkush@discussions.microsoft.com> wrote in message
> Hello all,
> I would to add ID number to each activity that is open, like a case
...Maintain PO Line item number sequence when one is deleted.
Once a PO is printed (released), if a line item is deleted, all subsequent
line item numbers are resequenced. I would prefer they are not resequenced to
maintain accurate history and to all me to tell the vendor that line item 13
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 not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree"...Publisher 2002 not showing page numbers
I have just installed Publisher 2002 after drive crash
When I open Publisher and select a blank document, in this case a tent fold
greeting card, only the first page is accessible. There are no page numbers
to click to go to the 2nd, 3rd & 4th page.
Have searched around Toolbars, Options etc and can't seem to find anywhere
to enable this feature.
This is the only version of Publisher I have ever seen do this straight out
of the box?
Can anyone suggest where I might go from here?
Thanks In Advance
Lidoroll Pty Limited t/a
Cooma Computer Consultants
...Pivot-Like Query for Christmas?
SQL Server 2000. I have the following table and need to turn it into
something "flatter". Gurus, can you help me come up with any SQL
2000-compliant TSQL that can make this happen?
I have this:
CREATE TABLE #Pairs
INSERT INTO #Pairs VALUES(1,'Height','84','Int','Height of the Door');
INSERT INTO #Pairs VALUES(2,'Width','40','Int','Widtrh of the door.');
INSERT INTO ...Help with a Query 02-29-08
How would I do this in Access: I keep getting errors:
set Assemrec = source.Recno
from @Components target Join @Components source on '<$-' +
target.RefDes + '>' = source.RefDes
On Fri, 29 Feb 2008 12:54:11 -0800 (PST), "email@example.com"
>How would I do this in Access: I keep getting errors:
>set Assemrec = source.Recno
>from @Components target Join @Components source on '<$-' +
>target.RefDes + '>' = source.RefDes
This isn...how do I arrange by date, expence report that is random?
In Excel itemized expence report templet. If I enter all expences randomly,
from different accounts and dates,how do I arrange them by account and date
when I am finished?
Mark the WHOLE range of your data.
Tools>Data>Sort by Accounts, and Date
Save a copy of your file before you start - just in case!!!
> In Excel itemized expence report templet. If I enter all expences randomly,
> from different accounts and dates,how do I arrange them by account and date
> when I am finished?
select the data including the header row and do Dat...sequential numbering #2
I am hoping someone can help me with regards to an Excel formula.
I need the first column to have sequential numbering as it goes to the next
row, i.e. 1, 2, 3, 4, etc…The condition is as follows:
IF the 3rd column is blank, then the row in column 1 will increase by 1; IF
the 3rd column has “any” text/numbers (is populated), then the row in the
first column will remain blank until the 3rd column is once again blank and
at that point, it will once again increase in sequence, to the next
number…Does that make sense?
So far I have this: =IF(C17="","",1)
It works great ...random pages
I have developed pages that randomly define a set of normal lung
function data based on gender, age and height. I have applied formulas
to this data simulate 5 classic lung function abnormalities (normal,
restrictive, obstructive, mixed and early obstructive.) Currently
the sheets that define the abnormal are named by one of the above lung
abnormalities. I would like to present data from random pages in a
work book to students and rather than have the pages named by the
abnormality be named a simulated patient name.
Can I have the name of a sheet set to equal data from to ...Random freezing
XP on this workstation will randomly freeze. While I'm working on it,
sitting idle. It will go for a week or more, then lock every day.
I've slowly reduced Hardware acceleration. Updated drivers, changed out
RAM, repair install. Even swapped out the power supply. Just when I
think I've resolved it, it freezes...
It doesn't happen with any other OS's on this machine.
Does anyone have a thought as to something I may have missed?
Anti-spam measures are included in my email address.
Delete NOSPAM from the email address after click...Random Number not so random
I am trying to create a random Job number when my form loads using the
onLoad event to process this:
Me.Textfield = Format(Date, "mmddyyyy") & "" & Int((99 - 1 + 1) * Rnd() + 1)
Which will create a job number like 08212007** with the last two numbers
being "random". The numbers are created fine, but ALWAYS the same numbers
are generated on the initial load and subsequent loads of the form as
and so on. I guess it really isn't a random number function in it's truest
...column filtering to match identical numbers
I have a master column that has 2000 numbers in the list.
I have a 2nd column that has 400 of the same numbers that exist in the
I need to take the 2nd column and sort it in such a way that the 400
numbers will be in the same row as the matching ones in the master
sammc2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19402
View this thread: http://www.excelforum.com/showthread.php?threadid=387364
Assuming A1:A2000 is the master data, and B1:B400 is the sortin...combination of numbers
Hello!!!! The problem that I explain below is one that i have for
long time... hope someone can understand it...!!
Is there any option in Excel, if I have a list of numbers (for exampl
20 different numbers), I want to know which combination of thes
numbers are the sum of "X" number??
ErnestoMarti's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2683
View this thread: http://www.excelforum.com/showthread.php?threadid=40081
Here's an example using the s...