Z Report Customer Count vs Hourly Sales
My Z report shows customer count of 380 and hourly sales total of 384. Why
the difference? This happens all the time.
Your glass is:
Half-Empty : Do folks at register forget to ask "Is there anything else I
can help you with?"
Half-Full: Your impulse items at POS are working -- better late than never!
> My Z report shows customer count of 380 and hourly sales total of
> 384. Why the difference? This happens all the time.
OlyBikes Locally-Owned B...Help: Formula put into entire row creates large file size
I have a spreadsheet where I would like one column to be the
concatenation of two other columns.
For example, in column C I would have =A1&B1.
This excel file will be given to people and they will fill in values
into columns A and B. The trick is, I don't know how many rows there
will be, so I don't know how many rows in column C should have this
If I paste this formula into the entire column C, the excel file blows
up to 3 megabytes. (It's only 15KB without this column).
Are there ways for me to accomplish this more efficiently?
Thanks for any help
Are y...plz help me .......[plz].....[i need a help [ :( ] ]
hi , every body;
i want to write an easy program;
if u have time plz write that code for me
i want to write a program that it gets a number from user then save it
i mean to see tahat number ever time that i want at that file
i need a help
On Mar 7, 6:04=A0pm, sahel <nam.nam.baro...@gmail.com> wrote:
> hi , every body;
> i want to write an easy program;
> if u have time plz write that code for me
> i want to write a program that it gets a number from user then save it
> in filestream
> i mean to see tahat number ever time that i want at that f...Printing one pg item (visio), only prints 2nd 1/2 of page. Help?
I have a one page flowchart in Visio 2003. It fits an 8 1/2 x 11 page on
print preview screen. When printed, only get 2nd half of the flowchart on the
page, as though it only started printing from that point. All settings seem
normal, am able to print normally in Word. Opened other visio flowcharts that
had printed normally 30 minutes ago, and now only getting 2nd half of page.
There were some printing issus with Visio 2003. Have applied the latest
patch to Visio 2003 and are you using the latest printer drivers?
John... Visio MVP
Need stencils or ideas? http://www.mvps.org/visio/3...Importing column in comma saparated values.
This is my first post here..:)
I have some values in a column in excel and I want to have them i
comma saparated values. The Outout can be in any type of file as lon
as I can copy it..I am sure, the experts here can solve this and hel
me a great deal...Please help...
Thanks in advance.
Message posted from http://www.ExcelForum.com
You could File/Save As then select .CSV ???
Message posted from http://www.ExcelForum.com/
If it's just one column (out of many used columns), then I'd just copy and paste
into NotePad and save from there.
But I'm not quite sure how y...Mid Month Report
I am trying to produce my financial statements mid-month to allow myself to
have a head start on how my company is performing up to that point in the
month. As we are a little behind on our books sometimes, I usually want to
review data up to the 15th of the month, but I wont have a chance to review
the data until approx the 20th.
Is there a way to specify the exact date you want to review data for in FRx?
Or at least a way for me to review the data desired as per the situation
In the column layout you can enter date ranges on your financial co...help
I have some texts files, which i want to read in each line, and then
write back each line to a new text file.
So for example, I want to read in the 2 lines below:
I store each line of data in the following vector:
So FileData =3D ""C:\Data\=D3=EA=D2=B9=D0=C7=BF=D5",6,10,3,3,8"
FileData =3D """,0,0,0,318.592,83.04552"
(the data is in the vector correctly)
Then I go to write the data to a new text file...
FILE ...Toggle Button Help 2
How do I configure a toggle button to toggle a cell between 2 differen
colors (in this case from blue to white and back)? I only have half o
the formula but don't know how to assign the other half of the toggl
to change the cell back to white.
Here's my formula:
Private Sub ToggleButton1_Click()
.ColorIndex = 8
.Pattern = xlSolid
How do I add the rest?
Message posted from http://www.ExcelForum.com
Answer Toggle question #2, you can assign the function:
Private Sub ToggleButton1_Click()
I...Please Help Me
Please help me im bearly making it ive got so many bills ive tryed providing
for my famlie but im bearly making it please send me $5.00 or more to help
out im just asking for your help if you dont have it ill just keep trying
click below on the link to send me $5.00 or more please help me
God bless you all
...Links in Excel 2000...need help
Would you happen to know how to switch the setting in
excel so that when I doubleclick on a cell with a link to
another tab (worksheet), it will take me to that tab and
specifically the cell referenced?
Maybe you can use a worksheet formula.
David McRitchie has posted these formulas that he uses.
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
but you meant like what hap...Page Orientation for multipage report
I am working on an application in where i have a 2-page report that requires
the front page to be landscape and the back page to be portrait. Is there
anyway to perform this task? I want to be able to print it two sided. I may
be able to try a solution that will allow me to create the back page in
landscape provided that When i print it it appears to be Portrait. The back
page contains many label and one section with text boxes populated by remarks
entries. If there is a way to rotate the dynamic portion of the report, I
think I can rotate the labels and try that. Or is there a wa...How can i stop same data being repeated in a column
I have a list of contract numbers relating to application numbers or
payments. they are in the format nnnnnnan or nnnnnnpn. The columns are fixed
to this format only. If they are entered with the a or p in the wrong place
or if they have been left out completely an error message will appear to
alert the user. I want to know how to alert the user if they enter an
application or a payment number that has already been entered.
ie if they enter 022079a4 but that same application has been entered else
where in the column.
Hope you can help
See Chip Pearson's
http://www.cpearson....help with 2 xl sheets...
I need help with 2 worksheets.
first sheet is a time schedule sheet. I need to count the total number of
shifts entered in a week
The sheet is set up so columns are days of weeks, each person has 2 rows,
top row is the start time bottom row is end time, time is entered is in 24Hr
format and shifts start at various times of days.
Second I have a row of numbers 1 to 20 that is averaged in row 21 in column
A. Row 1 has the most current figure, row 20 is oldest, Can I set it up so I
can enter the most current number in row 1 column A and all the existing
figures automatically bump down 1 row? ...Help
I am trying to configure Outlook 2003 for multiple email
accounts. I have so far set up 4 different profiles to
go with the 4 different accounts that I would like to
check with outlook. On startup of Outlook 2003 I have an
option of which account to check and once I select the
account, it opens right up and everything is working fine
except that I would now like to use a password log on so
that each ac count can have some privacy. 2 are mine and
I have one for my wife. I would like it to request a
password before it opens her account etc.
any assistance would be greatly appreciat...Help on XML Explicit
Hello, I am starting to work with XML Explicit. I am having problems
with the tags and the level they generate in.
Can anyone please help me, for I have looked aroung and it seems that I
am doing everything fine!!!
I am attaching below an example of the query and the XML it generates.
Declare @IdCat int
set @IdCat = 62
1 AS TAG,
NULL AS PARENT,
'' AS [p!1],
NULL AS [pc!2],
NULL AS [pc!2!npc!xml],
NULL AS [pc!2!idp!xml],
NULL AS [pc!2!nc!xml],
NULL AS [pc!2!m!xml],
NULL AS [e!3!xml],
NULL AS [e!3!ce!xml],
NULL AS [e!3!de!xml],
NULL AS [e!3!fe...CHM Help using MFC and VC6
I'm not certain I'm in the right place, so please direct
me if there is another forum where this question would be
1) Migrating an existing application from using WinHelp
to using HTML Help.
2) Building a new application to use HTML Help, using VS6
Everything I've found in the MSDN so far is suggesting
that building an application in VS6 to use HTML Help is a
brutal and bloody process. The preferred approach seems
to be use VS.Net. This doesn't make sense, since HTML
Help existed long before VS.Net. I can't imagine ...Is anyone on here with DVS Reporter???
I work at this german firm now and they use the DVS Reporter as a
add-in in Excel. I have never used this before in the US. Do you kno
whether there is some kind of support forum for it?
mariasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3172
View this thread: http://www.excelforum.com/showthread.php?threadid=51680
Can anyone tell me if a file that was accidentally saved over is
recoverable in Office XP?
One of my users "Saved As" then clicked on a wrong filename in the
dialogue box and saved over an important file.
Thanks so much in advance.
AFAIK not unless there is a backup.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
Attitude - A little thing that makes a BIG difference
----------------------------------------...Report OrderBy Not Working
Using Access 2007, I have a fairly simple report, with one group. In the
detail section for some reason it will only sort on one column. The group
sorts properly and I have the feeling the Group Level is in conflict with the
OrderBy. Any ideas?
Never mind. My bad. It's working. I was looking at the data wrong!
"John Lane" wrote:
> Using Access 2007, I have a fairly simple report, with one group. In the
> detail section for some reason it will only sort on one column. The group
> sorts properly and I have the feeling the Group Level is in conflict with t...Sys table Query to Obtain List of Queries used in Reports
Is it possible to query the Access 2007 Sys tables to obtain a list of which
queries are used in which reports?
If you've named your queries according to their functionality it is easy. To
get a list of queries from the system table use:
SELECT Name, DateCreate, DateUpdate
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=5));
The quewry has no idea where it will be used so there isn't any way for it
to give you that information. The recordsource is in code or it's name is
stored with the form or repo...Exporting to Outlook
I have a database I have created in Access 2002 which has the regular fields
like name address telephone number etc. However, I also have fields for
address, website, partners name, children's name, birthday and many others.
What I want to know is whether it is possible to import all fields from my
Access database into Microsoft Outlook? If so, how do I do it?
Try this. Populate a Contact record in Outlook - try using a few. Then
export it to an Access Database. Compare the one you just created with the
one that you already have. Massage yours to match the one you c...Report sorting 04-25-07
I have a table which has a column of text with numbers. ie; S976S, or S934L.
The leading letter never changes. I have now had to go to four numerical
digits but it does not sort right. If I add a leading zero, how would I do
one method would be to use calculated fields for the sort
Another would be to build your sort field as follows
Assumption: your field is one letter followed by a three or four digit
number followed by one letter
Left(YourField,1) & Format(Val(Mid(YourField,2)),"0000") &
Right(YourField,1)...Need help to sync Outlook with laptop
I am new to Office (2003) Outlook and would like to find a wizard or step by
step instructions on setting up my Vista Laptop to sync with my XP Desktop on
the same network. I need to keep both my Outlook calendar and e-mail in sync on
both computers. I have no idea how to get started. I'd appreciate it if someone
would point me in the right direction. -Bill
A good start is here:
Bill R MVP
"William" <firstname.lastname@example.org> wrote in message
>I am new to Office (2003) Outlook and wo...Help writing formula... multiple nested if/thens
Hi all, I am trying to create a spreadsheet that calculates allowable
(pro-rated) car rental expenses that employees can claim for a
conference that was held. The organization has agreed to pay employee
car rental expenses that fall between the dates of the conference 7th
Sept 2008 and 14th October 2008 (including both of those days).
However, some car rental contracts fall partially in this range, (as
some employees showed up early or stayed late for vacation), and
employees are reimbursed accordingly. I am trying to create a
spreadsheet that gives the number of allowable days (inside the ran...Rounding decimal values in forms and reports
Just for your information: Some months ago I asked a question about decimals
in presentation of numerical fields in forms and reports. Now I just happened
to bump into an answer myself, which seems to help me in most cases. A
numerical value (long real, double precision) has maybe 15 decimals. If the
field in the form or report isn't wide enough to show all 15 decimals, it
just shows #####. What I asked about some months ago was a method to show the
value with just as many decimals, as there is room for.
Now it seems, that if I make a calculation in a field of the select que...