Multiple Pivot Tables
I'm trying to accomplish something I'm not sure that Pivot tables can
1)I'm creating two pivot tables that have the same "Pages" but
summation of different data sets. I'd then like to place the two
pivots on the same page and then split the pivot (and thus creating a
copy of each possible combo) but with both sets of pivoted data on the
2)Is there a way to limit split pages so that it only provides those
with non-zero values
...No "line-in" option in sounds & audio devices
I am trying to use Windows Movie Maker to convert analog cassettes to .mp3
format. I have WindowsXP, and I need to have the "line in" option enabled in
"Sounds & Audio Devices", under the audio tab. The only option I have is my
default sound card...a SoundMax Digital Audio. Can you please tell me how to
enable the "line in" option? Thanks in advance.
> I am trying to use Windows Movie Maker to convert analog cassettes
> to .mp3 format. I have WindowsXP, and I need to have the "line in"
> option enabled in...duplex printing question, change record order to line up with other side?
i have a report that i need to make the opposite side match up with the correct record. it is setup to print 4 records, 2 across then 2 below. like 4 post cards on a landscape page. records for each customer need to match up with the mailing address on the reverse side. so the records are switched if i were to make the report right now. basicly records start 1 and 2 on the top of the landscaped page then 3 and 4 under. so on the reverse side records need to be 2 and 1 then 4 and 3 under. i havent made the opposite side for mailing address yet. i need some info on how i need to do this....table with multiple fields with lookup to same table
I will relate my issue to the Northwinds sample db. I would like my "orders"
table to contain fields for the products in the order (let's say 3 products)
that would have a lookup to the products table. Can anyone please tell me how
I could do this, or explain what other method to use.
=?Utf-8?B?SiBEYXZl?= <J Dave@discussions.microsoft.com> wrote in
> I will relate my issue to the Northwinds sample db. I would like
> my "orders" table to contain fields for the products in the order
> (let's...filter form on value from linked table
Is it possible to filter a form (based on table A) on a value in a table B
where the tables are linked?
I would like to filter the form records (Table A) by using as input the
company name (or part of it) from a textbox.
Message posted via AccessMonster.com
Sorry for this but I forgot
I would like to use like
as I already use it to filter the form based on values from another txtbox on
Message poste...balance transfers
...Accumulating Values in a Pivot table
Does anybody of you know, how I can show in a Pivot table
accumulated values (example)in each row:
Day Amount Accum. Value
1 50 50
3 75 125
8 105 230
.. .. ..
.. .. ..
and so on.
Maybe someone give me a tip.
Thanx a lot
That is one of the big advantages of using Pivot Tables
One place to start would be
Debra Dalgleish's Contextures.com/techtip.html
http://www.contex...Importing Data into Existing Pivot Tables ?
Can anyone tell me if it is possible to *import data into an existin
pivot table *(possibly from a excel spreadsheet(refresh) or with
query to a Access database table) **I need to do this daily with
pivot table if possible ! Thanks in advance !
jman559's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2945
View this thread: http://www.excelforum.com/showthread.php?threadid=49157
...Query: Link data between worksheets?
I'm trying to find a shortcut to save me some time.
This is the problem:
I'm setting up a master worksheet, and 30 to 40 "slave" worksheets tha
need to run off it (all within the same workbook). The slave worksheet
all retrieve data from the master. The data is setup to run across i
rows (i.e. Row 1 contains 1 record). Each record has an individua
identification number entered in column A.
Is there a way that I can tell the slave sheets to copy an entire row
based purely on the identification number entered in column A?
Thanks in advance if anyone can help, as this could ...Data Validation
I want to set data validation on a cell so that it will accept the following
(and only the following) text strings:
(1) "BR" (literally)
(2) "NT" (literally)
(3) "nA" where n is any positive integral numerical value including zero and
A may take any of the values "L", "P", "T", "V" or "Y"
(4) "An" where n is any positive integral numerical value including zero and
A may take either of the values "K" or "D".
Is this possible, please, and if so how? thanks
Return e...Filtering data on subforms
How can I filter data in a subform?
The subform is a datasheet linked to a parent form (field)
On Fri, 8 Jun 2007 22:37:14 -0500, "Alberto Rios" <email@example.com>
>How can I filter data in a subform?
>The subform is a datasheet linked to a parent form (field)
Base the subform on a Query selecting the records you want to see.
John W. Vinson [MVP]
...Tables in Outlook 2000
A user copied a table from Word 2000 to an Outlook email
message and sent the email to a Macintosh user. The Mac
user cannot read the email with the table in it. The
message shows up as an OLE attachment. I asked the user
to send it as a regular attachment to the Mac user instead
of sending the table within the email. Is there a known
issue like this between Mac and PC?
...Table formatting lost
I receive emails that started off in Excel as a short table. The
sender then cuts and pastes into Outlook. When the message arrives it
has lost all formatting for the table. Is there any solution apart
from sennding as an Excel attachment?
Do the copy as a Picture and then paste in Outlook.
Gary''s Student - gsnu2007k
> I receive emails that started off in Excel as a short table. The
> sender then cuts and pastes into Outlook. When the message arrives it
> has lost all formatting for the table. Is there any solution apart
> from se...Need access advise regarind linked versus imported tables
I have designed an application that uses a linked csv file as the main table.
The reason for this is because another user creates this file and jsut puts
it into a designated folder on their computer.
Here is the issue.
The csv file contains approximately 20K records. I cannot create any type of
index on a linked file. Am I better off importing the file into access (or
reading the linked table and inserting them into another table with an
index)? Is there an easy way to perform something like this? Will this
I am pretty new to access and am looking for any and all...Automatically adjust table row height in Publisher
Is it possible to have Publisher automatically adjust row height when working
in a table?
Mary Sauer MSFT MVP
"cdavetype" <firstname.lastname@example.org> wrote in message
> Is it possible to have Publisher automatically adjust row height when working
> in a table?
...Reporting table fields vertically
I've come across a client with a non-normalized table with sales of items
for eight different regions. So, the fields in the table are:
Typically the client is printing these sales in columns, with a report that
has the eight regions spaced horizontally across the page. Something like
ItemCode Region1SalesQty Region2SalesQty ... Region8SalesQty
However, they now need a report with the sales reported vertically, like
...get data form cells sequentially
I have a spreadsheet i am creating which is giving me some amount o
hassle!!! I'm sure it is possible to do this but i just cant figure ou
I have one worksheet which has many copies of the same table, eac
table is consistantly ontop of the other i.e. first table uses cells A
- G10 (a rectangle of cells).
The dates i am trying to use are in a pattern of a nine row seperatio
i.e. first date is in cell G2, next one is G11, next one G20, and s
I need to find out how i can make a formula which i could copy whic
would grab the date out of these cells in sequence for pl...pivot table 05-01-10
I have data on two worksheet and i want to analize data by consolidate them
togeter.How can i use pivot table?
> I have data on two worksheet and i want to analize data by consolidate
> togeter.How can i use pivot table?
Yes, you can use mutliple sheets connected to single pivot.
choose, Multiple consolidation ranges option in Pivot table and Pivot
Chart Wizard - step 1 of 3.
It is better to get the all data into single sheet and use pivot.
--...Line Chart #9
I have a line chart for month on month data
Jan'07 Feb'07 Mar'07 Apr'07 May'07 Jun'08
A 93 99 120 111 85 90
This is the Eg data. Is there a way to show difference in values.
For Eg : Jan - Feb there is a +6 difference. Then there is a +11
Is there a way i can show this difference on the graph automatically? Other
than manually inserting a text box??
Please don't multi-post. Cross-post if you must.
"Rajula" <Rajula@discussions.microsoft.com> wrote in message
I have searched all over for a way to export my outlook setting from one PC
to another, but have found nothing. I exported data and the import seems to
have gone fine. Can someone tell me if there is a way to export my settings
from outlook on one PC to another - including my account and display
settings?? Settings such as display the preview window below the email
My reply is at the bottom of your sent message.
MVP - WannaB <nospam at here dot priv> typed:
> I have searched all over for a wa...Merge & Sort Dynamic Lists w/ Data Validation
First off, let me say thanks to the Excel Usenet community that has
helped me over and over through these newsgroups. You are phenomenal.
Question 1: I need to create a BOTH box that will dynamically pull
names from both the "Chicago Office" & "Seattle Office" columns in my
sheet. It is extremely preferable to do this without VB Script if
possible to avoid the security warnings on opening the sheet. (Our IT
department will not budge on this..)
I have two lists of employees. Column A lists the Chicago Office
employees. Column B lists the Seattle Office employee...Importing data from an excel file
I have an excel file with contact data for customers. Now I want to import it
into CRM 3.0. I use the guide but I am stuck at the manual import i.e.
populate CDF at step 5 in the data migration framework application. Do I have
to go to the SQL server and select the database and import into the contacts
I am really sorry for the newbie question..
You will indeed need to populate the CDF tables. You can do this via several
ways of which using SSIS is my personal favorite.
Hope this helps,
Ronald Lemmen - MSCRM MVP
http://ronaldlemmen.blog...2 existing spreadsheets show 1st line rather than header row to sort ...
This is odd, I haven't seen this ever before. I was working on
spreadsheets yesterday for a mail merge. Two had headers rows. I
cleaned up both documents, put print area and then tried to sort. In
both cases, what came up in the sort was the first row below the
header where one always sees the actual titles of the header row when
one selects the Header Row radio button under "My List Has" in the
I fiddled and fiddled a bit and managed to get one of the workbooks to
display the sort properly by the header row titles - without figuring
out what ...Pvt Table Question
I am creating several pvt tables that will be updated often with new
data. I want to know if there is any function within a pvt table that
I can use to set up my pvt table so that only the top 10 data points
are automatically displayed. So for example, if i have pvt table set
up to show brand name and then accounts for each brand name and I
sorted on accounts descending and only wanted the pvt table to show the
top 10 brands that had the highest total accounts. Is this possible?
To show the top 10 values for a field - double-click the field heading,
click 'Advanced' ...How to Populate .msg File Used in Command Line
I have a .msg file I saved as a boilerplate for Calendar requests that will
be programmatically started in an application I am developing. I want to be
able to modify the Calendar request's date, time, duration, and message
contents based on the user's inputs prior to opening the .msg file. After
the user verifies the contents, he/she will click the <Send> button.
Currently, from the command line, I can run
"c:\program files\microsoft office\office12\outlook.exe" /f
The Calendar request opens with the boilerplate. Ho...