PC Review


Reply
Thread Tools Rate Thread

Access Query

 
 
Walmondo Kelly
Guest
Posts: n/a
 
      10th Jan 2008
I have two fields in my query. One is a totals sum and one lists about 40
different brands. In the query for the brands field I list the two leading
brands on different or rows. What do I need to enter on the third row so that
when I look at this in pivotchart view I have the two brands in columns and a
third column which includes the totals or the two leading brands plus all the
other brands total?
--
rjk
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access metadata repository generation query, matrix generationquery, table-generation query, array-generation query. Roy Roebuck Microsoft Access Database Table Design 1 20th Dec 2008 07:23 PM
Writing a VBA Query for MS Access and have it show the Query Object Window Pete Straman Straman via AccessMonster.com Microsoft Access Queries 5 4th Feb 2005 06:08 PM
Linking problem - Access query to MS query to extract data to Exce =?Utf-8?B?RmF0TWFu?= Microsoft Access Queries 0 23rd Nov 2004 06:43 PM
Coworker modified base query, now form does not allow access to query. Brainwave Surfer Microsoft Access Forms 2 20th Aug 2004 02:20 PM
RE: Access 97 convert a xtab query into a make table query =?Utf-8?B?SmVuMTIxNw==?= Microsoft Access Queries 1 15th Apr 2004 05:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:46 PM.