Data labels: need value AND % change
I'm working on a series of column charts that show annual data for #
sold, $ volume, average price, median price, etc. I want it to show
the 2002 and 2003 values for each of these but I ALSO want to be able
to show the % change between the 2, so we can see trends.
So far, I only see that you can label the data with the value, or the
percentage. I haven't seen how you can show the values AND the %
change. Any ideas? I'd really appreciate it!
Message posted from http://www.ExcelForum.com/
Create the desired label in a separate column (the 2003 price
concatenated with t...Need help bring over GP 7.0 data to new a GP 8.0 server.
I'm setting up a GP 8.0 Test Server with SQL 2000 SP3a installed. How do I
bring my Great Plains 7.0 Data into the GP 8.0 envirnoment?
Thanks in advance,
The easiest way is the following:
On the 7.0 server, detach DYNAMICS.
Copy the DYNAMICS mdf and ldf file from the 7.0 to the 8.0 server.
On the 8.0 server, attach and browse to the mdf that you copied.
On the 7.0 server, attach DYNAMICS.
Repeat for all databases.
If you also need the sql logins from the 7.0 server, there is a TK on how to
do this (uses a table called RecoveryMaster within Dynamics db). If you can
go without the s...Save data as it is enerted.
How can I get my form to store data that I enter in a field, so that next
time as I start to type the same data it populate the rest of the data. For
example, if I enter a company name "My Company" the first time, the next time
as I start typing "My..." it should populate all company names that begins
with those letters and have been entered before. Possible??
Message posted via http://www.accessmonster.com
Forms don't store data, tables do.
If you want a way, on a form, to see a list of the company names that match
what you are typing in, take a look at how th...SQL Delete Layaway at HQ
Looking for an SQL command that will delete an entire Layaway in HQ. Example
delete Layaway number 57. Thanks for any help.
Never mind. I used
DELETE from [Order] WHERE [Order].ID = '57'
> Looking for an SQL command that will delete an entire Layaway in HQ. Example
> delete Layaway number 57. Thanks for any help.
Don't forget to delete any of the Item information from the OrderEntry table
for that order also.
"nt8378" <email@example.com> wrote in message
news:9B17957F-2696-446C-B08...SQL Error 'CoProcess' fail accessing to SQL data
I have two companies in my Great Plains Server, i make a backup of first
company and restore that in the second. but when a attempt to access to
second company whith any user, and I have this error:
una obtener/cambiar primero operacion en la tabla 'coProcess' ha fallado al
acceder a los datos SQL
Before you restored the company1 to company2, did you add the users to have
acces to company2?
If not you will need to add the users to company 2 within Great Plains
system menu (uncheck the SQL options to apply this). Can you logon as the
&qu...File error: data may have been lost.
What could be the cause for system to pop up such message when opening an
Excel spreadsheet in Japanese. The spreadhseet is created using Excel 2002
in Win XP Japanese.
if you cannot open the file, try this:
open a new workbook.
Insert > Object > Create From file> >browse to file then
This creates a picture linkt othat file. Click it and see
It worked for me when file became unopenable.
>What could be the cause for system to pop up such message
when opening an
>Excel spreadshee...Copy data between access databases with slightly different structures
If I have 2 databases with some differences in table structure, 1 is fully
populated and the other empty, how can I copy only the matching fields data
from one to the other? Are there any utilities available for this?
See if this is what you want. Open one database and create a link to
the table in the other database. Then create an append query. You can
choose the fields you want to append, leaving the other fields alone and/or
use criteria to chose what records you want to append.
Joseph E. Meehan
26 + 6 = 1 It's Irish Math
"Partha Mandayam" <partha@partha...Problem with data using IF and Nested IF statements possibly???
I am attempting to analyse data from multiple worksheets from numerous
people the incoming data all has one thing in common column A this is a
certain frequency a job is done. The problem is that there are many ways of
entering the data ie 12 months or 52 weeks or 365 days all essentially
meaning the same thing.
My idea is to collate the data in col A and then using the Helper column as
the standard frequencies ie if cell A1 = 12 months, closes frequency in
helper is 52 weeks therefore value in C1 = 52 weeks. By using an IF
statement I can change the value of one frequen...Export data from the same cell from multiple spreadsheets into a n
I am working with weekly timeshets in Excel and I am using the same form
every week, but save it as a file named "Timesheet 20100122" for a week
ending on Fri, Jan 22, 2010 (Our accounting week period). Therefore the daily
hours appear every week in the same cell. I would need to export these hours
to another - summarizing - spreadsheet (For example and invoice spreadsheet)
somehow automatically. Any help would be welcomed.
Thanks for your help,
Regards Ron de Bruin
...Hooks & sending data to the Pole Display
I am trying to send my own text during a transaction to the pole display. I
have everything in place and outside of RMS I can send stuff to the pole
display out the COM port, but when the hook is running during RMS POS I can
not my dll to talk out to the pole display. Is there any tricks to this that
anyone has found?
> I am trying to send my own text during a transaction to the pole display.
> I have everything in place and outside of RMS I can send stuff to the pole
> display out the COM port, but when the hook is running...Import #2
I want to import contacts against accounts. But wherever there are multiple
contacts to a parent account crm 3.0 doesn't allow the import. Any ideas for
You can use scribe or write your own import routine for multiple contacts
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. firstname.lastname@example.org
"Faiz Amir" wrote:
> I want to import contacts against accounts. But wherever there are multiple
> contacts to a parent account crm 3.0 doesn't allow ...Importing of customizations is not complete
I develop on a separate server, the customizations are exported and then
imported and published on the production server. Even though I get no error
messages not all customizations are loaded in the production CRM!
As far as I can judge it concerns relatively "small" modifications such as
the modification of the display name of an attribute. I can find the modified
display name in the XML file but it doesn’t get loaded!
...Exporting and Importing data
I am replacing my bosses machine with a new dell laptop.
I need to move his outlook over and he wants it exactly as
it is on his old machine.
Will someone explain the easiest and most efficient way to
If you are using exchange mailbox then the only thing you need to move over
is your boss's .pst and .pab files. If he don't have those two files then
you don't need to do anything. All the information is stored on the server.
Just reconfigure the new Outlook with his exchange mail information.
"lsoliz" <email@example.com> wrote in...How Do I Share Data Files?
I need to deploy an application which shares data among all users of a
computer. I thought I could do that by putting the data file in the
Common Application Data folder. However, that doesn't work because
Vista is using virtualization to make a unique copy of the file for
each user, so it isn't being shared.
How do I deploy an application with shared data? Is there a document
anywhere that describes the best practices for folder usage in Vista?
...Copy data from Word macro to excel
I am working on a combined Word and Excel sheet (Both 2000 version)
What I am trying to do is capture information in Word in an Userform
The information that is entered in the form is then used to fill out
word document that can be send to a customer.
However this information also needs to be entered into an excel sheet
currently that is done manually. But I would like to automate that wit
The data that is being captured is in the following form:
-If bolOKButtonPressed Then
WordBasic.SetDocumentProperty "ProjectTitle", 0
WordBasic.SetD...look up a selection of data
I would like to transfer or look up data when keying in a reference
number and bring up all the data regarding the ref number
Cell A1 = 101, B1 = John and C1 = january
Cell A2 = 102, B2 = Mark and C2 = january
Cell A3 = 103, B3 = Sam and C3 = February
Cell A4 = 101, B4 = John and C4 = March
Cell A5 = 101, B5 = John and C5 = June
When I key in Ref 101 in a chosen cell (eg.A10) then the display should
have all the details
Cell A11 = John, B11 = January
Cell A12 = John, B12 = March
Cell A13 = John, B13 = June
I assume A11, A12 and A13 should also have formulas to generate data
but I c...Smart list data not in tables
I have alot of data that for some reason is in the smart list but is not
veiwed in the tables....any easy way to get the data back in the tables.
Have you used some tool like Query Analyzer to view the suspected tables? If
you will tell me the SmartList you are trying to view, I'll give you the
tables. There is no way SL is showing nonexistent data; it's just a report
"Mike R" <MikeR@discussions.microsoft.com> wrote in message
>I have alot of data that for some reason is in the smart list b...Import Emails
Is it somehow possible to import all "old" emails from Outlook to MSCRM 3.0
History? Same question to the Journal Entries...
Has anyone done that before?
Thanks for any Help.
I'd like to see an answer to this question too. I've just installed CRM 3.0
and imported my accounts and contacts no problem. I now have 15 email inboxes
that each contain 1000s of emails that I want to load in as activity history
- matching them up with the contact records. I know you can do this 1 by 1,
but it takes about 10 clicks per message. Is there any way to automate thi...Is there anyway to import a file from Illustrator to Publisher? #2
I work with a graphic artist who uses Illustrator on a Mac. I need to import
her files (including graphics) into Publisher to use to do mail merges from
an Excel spread sheet. I am running Publisher 2007 on Windows XP.
Many thanks for any help.................
Can't be done. If it was a file on your computer, you could try a copy and
paste but there's no common format for the two programs.
Microsoft MVP - Publisher
How to ask a question
"maggie94306" <firstname.lastname@example.org> wrote in ...Exporting & Importing Knowledgebase 'Subjects'
I have defined lots of subjects in my development CRM instance and would
now like to import/export these to the production system.
Is there a procedure for this?
If not would the recommendation be to use the Data Migration Framework?
(massive hammer for this small nail).
Angus Logan (MCAD/MCDBA/MCP)
Lead Software Developer
Microsoft Application Solutions
...HQ CLient Error #2
I have got a runtime error 6 overflow whenever i go into HQ Client
configuration, I have uninstalled RMS restarted my PC and then reinstalled
RMS and i still get this error this is RMS version 2.0.
Please can some one help as i am really struggling with this!!!
I have looked and the only runtime 6 post i can find is to do with transfers
having a large number but there is nothing i can see in HQ Client that is too
long and cannot get into configuration.
I receive some prospecting data in a format where:
Odds rows contain client name: John Q. Public
Even rows contain salesman name: Assigned to Alfred E. Newman
Odds rows contain location information: Northeast
Even rows contain various data to be deleted.
What I want to have as an end results would be:
Only client name
Only salesman name
I need to:
1) Leave data in Column A odds rows
2) transpose data from Column A even rows to Column B
3) delete data in even rows in column B
4) transpose data from Column B ...Pivot Tables as Data Source
Does anyone know how to create a Pivot Table with
multiple Pivot Tables as it's source? The source Pivot
Tables retrieve data from different locations and are
structured in the same way as each other, with the same
dimensions - I would like to produce a summary Pivot
...Backing up Money data to online location?
2003 does not allow an easy way to save a back-up to an online location,
such My Yahoo briefcase. I have to take the file, and upload it manually.
Please correct me if I'm wrong.
Will there be an online back-up option in future releases? I'd like to see
it go to MSN via my Passport, for instance. I'd upgrade for that.
Given the size of a backup and the availability of sync with the web, this
might not make it anytime soon.
"Iron Flatline" <email@example.com> wrote in
> 2003 doe...WM5/Mny2006 Account Register Data Input
I'm using Money2006 on WM5/VGA, work fine in portrait mode until a trial
version of Lingvosoft Dict, was installed, the Input field width & dropdown
menu boxes under ACCOUNT REGISTER was slightly enlarged and got pushed off
the right screen, now the dropdown button can only be accessed by setting
the ppc in landscape mode, appreciate if anyone could provide info how to
correct this problem. btw, I've uninstall and trial-ware and reinstalled