HELP! Need to export hourly sales data on POS (NOT RMS)
How can I export hourly sales data across a date range? For instance, I
want to show hourly sales for the month of October so I can graph it and
post it in our break room.
If I can't export hourly data, can I export daily sales?
The built-in reports don't address this data format.
This is a multi-part message in MIME format.
Mark, This should work for you. Keep in mind it takes up to 5-10 minutes to
load...Help with income/expenses
Running 2003 in home page I setup income and expenses I prefer to see one
whole month. Money some how shows it as 1/22/2006 through 2/20/2006 any way
to fix this?
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
...help with simple maths in excel
I want to do a simple arithmatic excercise in excel for my grand daughter.
It is stuff like 2+2 =4
Smart me has hit a problem at the first hurdle...
I need to put 2 in one cell the + in another cell and then 2 in another = in
another and then she puts the answer in the next one. So the above would
have 4 cells completed and she would put the answer in the 5th one.
When I use the + or = sign in a cell of its own it (excel) thinks I am doing
an equation, is there a way around this?
I will work on the answer like if she gets it correct or wrong how I will do
that...a sound or som...Need help with Auto Filter
I have a spreedsheet that is filtered in multiple columns. I am running a
"Subtotal" function to count certian rows when I filter the column. My
question is this. Is there a way to save or freeze the data that the
subtotal function counts in a different cell. In other words I want subtotal
to count everything in a particular column but I want to be able to save that
number somewhere so that when I filter again with another variable I am able
to still view the first subtotal to compare the two. I hope this makes
sense and thanks in advance for any assistance you can provi...Can anyone help ?
I have created a holiday planner for staff with in are company
and i need a formula that gives us only 10% of the total number of staff are
off on holiday.
would be greatful if anyone could help.
Hello - If you have a total somewhere (I would suggest inserting a column on
your spreadsheet titled Total and then entering a "1" if the person is going
to be out, then total the column of "1"s by entering "=SUM(x:y)" where
x=first cell in the range, and y=last cell in the range), in a different
cell, enter "=.1*z" where z equals the total of people out...HELP! remote data not accessible msg
I have a use who is currently using a Bloomberg DDE add-
in. Whenever he attempts to activate the add-in to
retreive remote data, the system hangs. If I go to task
manager, I then see a message stating "Remote data not
accessible. To access this data Excel needs to open
another program.... I have searched the knowledge base
and didn't find much help. Does anyone have any ideas? I
am desperate!!!! We are currently using Excel 2003 in XP
...Help with a simple database
I am attempting to use Excel to develop a simple database for my office.
The database basically lists a variety of orders purchased from various
vendors, and my goal is to categorize and sort each vendor seperately.
GC Group 4/24/03 7831.1 $1,000.00
Alpha 1/20/03 7003.1 $2,000.00
Chandler 5/6/03 7050.1 $345.50
Is what the main chart looks like. Now, what I'm trying to accomplish
is, suppose I added
Tomsen 4/20/03 7873.1 $200.00
to the very bottom, Excel would automatically create a new tab (or even
worksheet, if possible) tit...Looking for help on timing within a function
At the facility I work, our associates use a very basic access database to
sign out individual work orders on an interval of around every 12 minutes.
They have asked if it would be possible to put a timer on the front page of
the database to show how long they have been working on the current work
order, updating each time they sing out another order.
I am not very adept at access nor is the rest of our management staff. Is it
possible to add this function, so they can better keep time of their work
Use the Form Timer event. Here is an example of how it can be done. In this
ex...Need Query Help
I have two tables, Table A & Table B, in my database that have the
same fields (Name, SSN, etc). Most of the records in both tables are
identical, but each table has some unique records. I would like to run
a query that will select the unique records in Table A by comparing
SSNs, and then do the same for Table B.
I am a database novice, and have tried all the wizards and expression
builders with no luck.
Any help at all would be appreciated. Thank you!!!
Casa Grande, AZ
The "Find Unmatched Query Wizard" is what you need. If you only want to
check for SSNs ...Excel Problem
I have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to
my local hard drive. Every time I try to open it, it takes forver and
sometimes never opens but I do not get any error messages, let me just tell
you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else
running when I try to open it. As I said it is set for manual calculation,
and it is cleared to not auto calculate when opening or closing. Any idea's
as to why this is happening?
I don't know why you're having this problem but I would like to point
something out for w...Please Help w/ Large Excel File
Hello everyone. I have this Excel file that has drawing text box objects in
the document. When I delete a text box the attributes still are present,
but just not showing. It is continually growing my file size. When I
export the document to HTML after deleting all the text box drawing objects
and saving the file, the text box objects still show as vtextbox elements in
this file. I tried to reproduce this with a new Excel workbook but could
not. I would be greatful if anyone can figure this out, as I have a lot of
documents to re-create if there is no solution. Thank you.
exce...HELP in printing A3 size newsletter-magazine which has a centerfold.
hi! i want to print a newsletter magazine in A3 size. so that means, the
newsletter must have a paper size of H:17" and L:11". When i set the paper
size in mspublisher to A3 portrait, the centerfold expands to h:22"....
which consists of two A3 size papers.... how can i correct this so that
each page will print like two short bond papers combined in the middle?
also, how can i set mspublisher to print without borders? in my printer
setup, there is a borderless settings. problem is, if i select that, some of
the layout will be cropped out in the borderline.... so it look...vlookup Help!
I have a Excel workbook which has multiple worksheets (tabs) tracking my
agents stats from day to day. My data is not on the same identical cells from
worksheet to worksheet. I am trying to use a Vlookup fuction to pull the
specific data that I want from each worksheet, and get a return SUM total for
my summary page. I hope you can hlep me with this problem or have a better
solution. Thankyou Tommy
Maybe I an give you a small example and you can expand it to suit.
Formula in sheet 1, A1 =VLOOKUP(B1,Sheet2!A1:B5,2,0)
Data on sheet 2 A1:A5 = A,B,C,D,E, which represent the sales...Workbook_Open Help #2
Here's the code
Private Sub Workbook_Open()
Call Unhide_Sheets '
Fable's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=218
View this thread: http://www.excelforum.com/showthread.php?threadid=26252
and there's no application.screenupdating=false statement in your
"Fable" <Fable.1d07w...NEED HELP importing database into new install of Exch 2k
I am a small business owner, and we have one main, multi-
homed box. This box is a Win2kAS PDC, DNS, IIS 5.0, Exch
2k, & file server. Last week the registry was zapped by a
RAM parity error, and the system went into a perpetual
reboot mode. I was able to slave the OS drive (we have an
OS, and two mirrored data drives) on an XP pro machine to
see if I could see any of the data, luckily it's all
there. Unfortunately, we didn't have the registry or
exchange databases backed up.
I've installed a new drive, reinstalled Win2kAS, re-setup
AD, IIS 5.0, Exch 2k, and other apps....Please help
I hope someone can help me out with this because it is creating a very big
hassle for me. In the old 2000 version of Excel, it is possible to paste
results directly from a Query Analyzer table (or any other table for that
matter) into the spreadsheet. It would match the data cell for cell.
However in 2003, it seems to paste the an entire multicolumn table of
results to single column. Does anyone know how to fix this? Is it a
setting or something in 2003? Any help at all is appreciated.
No setting as such that I know of. Don't have analyser installed but tried
...Custom PageSetup dialog & help
I have a custom PageSetupDialog - done by following steps recommended by
MSDN. I have a custom dialog resource built by adding a few fields to the
standard page setup dialog dialog resource, and have used the
PSD_ENABLEPAGESETUPTEMPLATE flag to get my dialog. It all works as
My application has help files setup and I have handlers for the various help
messages (ID_HELP, ID_HELP_INDEX, ID_CONTEXT_HELP etc.). When the
application is running and you are at the custom page setup dialog and press
the F1 key - a context help is displayed for all the fields that the
standard Page setup...Help with graph
I have cells with info in them (� values), each set of cells has a name, say
J2 has mary smith in it.
I then use this info for a graph chart.
Is there a way to automatically get the name mary smith onto the graph
I know how to do this manually but is there a way for example =J2 and this
would do it for me?
You do not say exactly where in the chart you want the name to appear.
But if you mean as a data label then nothing automatic, unless the name
is already defined as either the series name or category labels.
There is however a free addin that makes the as...Please help! Outlook cannot read mailbox!
I have a huge problem.
I'm using SBS server. I've created a user. They can access their e-mail
from outlook web access, but not Outlook itself. In outlook I can't
even create a new exchange account, as outlook cannot find the user.
Hope that someone can help
Btw, I see this in my event log:
Information Store (3288) First Storage Group: Index FoldersIndex6 of
table Folders is corrupted (0).
If OWA works the problem must be with the client or name resolution.
1. Is name resolution from your client to the Exchange server working
2. If name resolution is not an...macro shortcut help
Hello I have a Macro set up in spreadsheets I have made for multiple people.
I have set it up so they can paste the info needed in a worksheet and then
use the shortcut ctr(a) to run the macro below to delete all rows with lab in
Dim rng As Range
Dim what As String
what = "LAB"
Set rng = ActiveSheet.UsedRange.Find(what)
If rng Is Nothing Then
This worked well for a while but now I find that the shortcut is n...Re: My category heirarchy got messed up - help!
Thanks to Cal's suggestions and Dick's FAQ - Q5/A5 (fascinating reading!), I
think I've recovered from my "corrupted" file problem described in an
earlier posting today.
In case you're interested, I suspect a recurring bill with the "Fitness"
sub-category was the problem. I had that bill set up to automatically post
to the register 3 days before the due date (why? I don't know - I won't do
THAT again!). I restored a backup from 2 days ago that didn't exhibit the
problem, deleted the offending recurring bill, re-defined it, and entered
...Help! Can't open Outlook Express
Help! I can't open Outlook express. Whenever I try to a
message pops up that says, "Outlook Express could not be
started because MSOE.DLL could not be loaded. I've tied to
download another Outlook Express. But It says I need
Internet Explorer 6 but I have installed it. Please Help!!
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for...Help, please, Re: DST/ Outlook patch
Using Outlook 2000 and Win XP...
I downloaded and installed a patch from Microsoft's website, to address the
change in Daylight Savings Time... (Northeast US).
The time on my PC is correct, however the patch has moved every appointment
I had set up in Outlook, by one hour.. As you can imagine, now I am double
checking every entry to get the correct time...
Why would it do this??????????
The time of day changed, not the time of the app't!
Help? Is there a fix for this fix?
Did you then apply the TZMOVE.exe patch for Outlook after you appl...help please?
Hi, I'm trying to go to college... I am about 4,000 dollars short.
Financial Aid came up short this year. I'm in my junior year and I'm
afraid I won't be able to go this semester. I was wondering if anyone
would consider donating as little as a dollar through paypal to me.
Anything could help!
Please consider! This is not spam... if you need proof my college
attendence, I'm willing to send a copy of financial transcript and
report card. If you have any questions, please email me at
Rudyskagirl@gmail.com... thank you so much for reading...Help- Changing Case
Excel 2003: I need to change the case on imported data from "CAPS" to
"Proper". I thought it would have been an easy process but I was wrong. Any
help would be greatly appreciated
Select the cells you want to make Proper and run this small macro:
For Each r In Selection
r.Value = Application.WorksheetFunction.Proper(r.Value)
Gary''s Student - gsnu200738
> Good morning:
> Excel 2003: I need to change the case on imported data from "CAPS" to