Pivot Table: use a field in two different places
Two related questions:
1. Is there anyway to display a field in two different places. For example,
I want to put a date field in the page part of pivot table. However, I also
want that same date field in the row area. So when I choose "all" dates on
the page filter, I will be able to see the individual dates in the row as
well. Right now when I try to add the field, it takes it out of where it
used to be. i.e., when I add to the page, the row field disappears.
2. I want to group dates by month. But I also want to display the
individual dates in the row area righ...How To Type a simple 5 page Sales Letter with Text Only
I'm BRAND new to this. ..and so lost. I simply want to
type a 5 page sales letter on blank paper with nothing on
it but text.
Can't find any letterheads that don't have a design on
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Diane <email@example.com>...
> I'm BRAND new to this. ..and so lost. I simply want to
> type a 5 page sales letter on blank paper with nothing on
> it but text.
I would recommend Microsoft Word for this. Publisher is more oriented
around designs that have more than o...Table all in uppercase when imported into Access
I am importing a Dbase III table into MS Access, All of
the text fields are in uppercase (Approximately 17,000
records). My question is how can I convert all of the
text fields to lower case with only the first letter of
the field in Upper case such as name, address, city and
THERE'S NO EASY WAY
There's No EASY Way <g>
You can write a VBA routine or function using UCase or LCase (convert case),
and Left$, Mid$, Right$, Instr, or Split to pull the string apart, or
StrConv(string, vbProperCase) might be a good one.
The trouble with names and addresses, is th...How can I get a combo box to get data based on a text box?
I have a text box that looks up an ID number from a table. I want the
User to type in an ID and then have a combo box on the same form that
gives a list of dates that correspond to that ID in the text box.
Right now, the combo box displays all the dates from all the ID's. I
want it to only show the dates that are linked to that ID.
Use the text box's AfterUpdate event to modify the combo box's RowSource
Me.ComboBox1.RowSource = "SELECT ... FROM ... WHERE FieldID=" & Me.TextID &
firstname.lastname@example.org wrote...Multi Table Queries
At my job, I use enter data through generated queries. However it appears
that I can only ENTER data in a query when it is based on two tables. If it
is three or more, it doesn't let me enter any info.
Is this normal? Am I doing something wrong?
>At my job, I use enter data through generated queries. However it appears
>that I can only ENTER data in a query when it is based on two tables. If it
>is three or more, it doesn't let me enter any info.
>Is this normal? Am I doing something wrong?
Yes, that's common. You should only edit data ...Text to Columns 06-01-10
I have a column where I have names and surnames. I want to put name in one
column and surname in anoter column. In order to do this, I use Text to
Columns, but I have the following issue: if the cell contains for example
Juan Pérez, it works ok, but when the cell contains Juan De los Santos, it
assumes there are three surnames, and then put me one word in each column.
This is the result, with the example mentioned:
A B C D
Juan De los Santos
How can I indicate that...Merging "space" and character into existing text cell
I would like to merge text into an existing cell with text. However, I
need to add a space and the dash " - " character to the existing text
before I do this. Is there a formula for this process? Thanks.
If your existing text is in A1, your text to add in B1 then in C1 you
=A1&" - "&B1
This adds the space before the hyphen and after the hyphen.
SteveG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7571
View this thread: ...Can you make a Rule to test the absence of words?
Outlook 2003. Is there a way to create a rule that tests for the absence of
words or phrases? For example, "move the email to x folder if the subject
does NOT include "word y".
Yes, you can construct a rule with no conditions, a move action, and an =
"except if subject contains word y" exception condition.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
I am using Office XP. I am working with word and I inserted a table and a
pasted images into each cell. Now I am copying the whole document and I am
pasting into PAINT. Now I hide the gridlines in word bur when I paste into
Paint some of the grid lines still show up. Why?
Likely because it is an Image, the grids are still there, just not
visible in Word.
> I am using Office XP. I am working with word and I inserted a table and a
> pasted images into each cell. Now I am copying the whole document and I am
> pasting into PAINT. Now I hide the ...Purchase Resolution Tables
PRW tables in Great Plains - are these tables temporary tables populated only
when the purchase resolution is run?
Im asking because i want to extract data in crystal from the PRW40034 table
but cant seen any PRW tables via crystal.
I reckon these PRW tables are names of once before existing tables in earlier
versions of GP - i believe the tables I want are the MPO tables
If this is 100% (im at about 95% with this) its a shame MBS havent cleared
up the table list to NOT show tables that are no longer used.
> PRW tables in Great Plains -...Outlook erased on Word repair
I had a glitch in Word xp that I elected to do a quick
detect & repair on... only to find that it nuked my
Outlook completely away! Nuked hundreds and hundreds of
email addresses, and thousands of email's, important
clips, attachments, and the lot. Gone. Way to f'n go
microsoft. I'm switching to Eudora...
What kind of an irresponsible piece of f'n crap this has
This is akin to my car's radio getting a stuck Cd in it,
and the result is having the car's engine vertically eject
through the hood. Absolute, unmittigated dung.
For years I used to work...Translating Dialog text
Firstly I am new to MFC so apologies for what is I am assuming a very
Summary: I am writing an MFC application which contains one simple
dialog and up to 6 message boxes. I need to provide the application in
both English and German. The dialog contains a title and static text,
both of which will need to be translated. The buttons on the dialog
will also need to be translated. The 6 message boxes contain text to
be translated, titles to be translated and the button names must also
be transated. In total there will only be about 10 strings to be
My questions ...One table
I am receiving the following XML:
where element <C> is nested with both elements <B> and <D>.
If I try to generate a dataset so I can load the XML, I
get an error saying "The same table (C) cannot be the
child table in two nested relations."
Does anyone know what the XML schema needs to be in order
to create a dataset that will load this XML???
...HTML Table Selection
Can any one tell me how to select a single column of a
table in HTML page. If u select a column now,
from the next row onwards all the cells will be selected.
I want only the particular column. How to do that?
...extract text from html files #3
Looking to do this with a macro I guess. I need to do lioke 20,000 + of
these, So doing 1 bty one, isn't what I am looking for.
Please help, Need to figure this out. Even if it can not be done easily
or by me. Let me know who I can ask if they can do a program, etc.. for
...body of email disappears when I send an email from Excel
when I am in Excel and I email a spreadsheat to someone as an attachement I
always include a message in the email. I send it without a problem, it
seems. When I check the sent message, the body of the email is no longer
there and it wasn't sent to the receipient.
...how do I get rid of ###### that appear instead of text in excel?
I used to know how to do this, but I've forgotten...grr...how do I get rid of
those nasty ######### that appear in the fields instead of what I enter...the
correct words appear up in the input header, but the field just shows a
series of pound signs...thanks!
Change the format of the cell from text to general. If text is between 256
and 1024 characters in length and the cell is formatted as text you the ###.
> I used to know how to do this, but I've forgotten...grr...how do I get rid of
> those nast...Data value display attributes linked to table attributes
Is there a way to cause data value points to take on attributes such as
bold, italic or color set at the table from which they are derived?
For example, suppose I was charting hits at several web sites as
function of time, and the some characteristic of the site was being
altered back and forth (say font "A" and font "B") as part of
I can easily produce a line graph x=hits y=time for the various sites,
but these is no way to visualize which condition (A or B) was in effect
at each data value point.
I'd like to be able to display the portion of each li...Defect in word 2007 to Word 2003 converter
I have recently run into an issue with the .docx to .doc converter in word
I was curious if anyone else has run into this issue - I have not found any
posts adressing this.
The problem is as follows:
Word 2007 document With an OLE embeded .doc > 25 MB Saves and opens fine in
When the .docx file is opened in Word2003, the embeded ole object icon is
present, but when the user clicks on the icon to open it, only the "Format
Picture" dialog box appears. If the user using word2003 saves the document
at this point, the data in the embeded document ...How to delete a text object?
I can delete most objects by selecting them and pressing the Delete
If I do that with a text object, the Delete key deletes a character in
the text inside the object. I have found that I can right-click the
object and then select Delete Object or I can press the Detele key
while holding down the Shift key.
Is there a setting that will make Publisher select just the object
with the first click and the text with a second click? Visio works
this way and it's much easier for me -- maybe because I'm usdd to it.
Running Publisher 2K SP-3 in Office 2K
OS: Win 2K SP-4 (5.00.2195)
...Summarising info from a table with 2 variables
I'm trying to find a way of automatically interrogating info from a table
with a series of data in columns, including MONTH and TEAM. The table
records site visits, with each line recording a separate visit.
In particular, I want to be able to automatically calculate the number of
visits achieved by each team per month. At the moment, I can't figure out
how to get it to look at all the variables. A colleague suggested a pivot
table, but I can't make that work either. Please help!
Post a small sample of your data, together with details of...How do I set up filter for page fields in pivot table?
I have a fantastic pivot table that I built that I use to answer questions
from by customers. However, the questions are often varied and I find it
difficult to easily select and de-select data. Is there a way to filter the
page fields in a pivot table. For example, I might need to go from seeing
all the data for one plant to the data for one material at all the plants. I
have over a thousand materials, over a hundred plants. So, going from one
set to data to the other is taking some time because I have to select and
de-select so many individual items. I would really like to add a...Word 2003 & Word 2007
I discovered quick picks in 2007. My question is, is there are similar
feature in Word 2003?
In Word 2003 there is AutoText; Quick Parts / Building Blocks are an extension of the AutoText feature in Word 2007.
Microsoft Word MVP
"TarynB" <TarynB@discussions.microsoft.com> wrote in message news:E34F2982-1DE3-4838-923B-6DAFA503CB66@microsoft.com...
>I discovered quick picks in 2007. My question is, is there are similar
> feature in Word 2003?
...Formating a Table that's nested in a FormView
I have a table that's located in the ItemTemplate and EditTemplate.
Each table has the same name. I'm trying to format the BgColor of a
specific color on PreRender. I know how to access the colomn
properties if it were on the page, but once it goes in to a formview I
can't seem to find it.
How can I access a table that's nested in a FormView?
"Dave" <Dave.Burkett@Jacobs.com> wrote in message
>I have a table that's located in the ItemTemplate and EditTemplate.
> E...CUSTOM TEXT FORMATTING???
My cell has 8 mixed characters of numbers and letters. I
need to have a hyphen "-" after the first 4 characters in
a column. Can I make a custom text format so no matter
what I enter a hyphen is automatically inserted? How do I
this could only be done with VBA, using an event procedure (as you have
text and numbers in your cell). e.g. put the following code in your
worksheet module (not in a standard module):
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A1:A100"...