PC Review


Reply
Thread Tools Rate Thread

Conditional format based on 2 records

 
 
Molasses26
Guest
Posts: n/a
 
      14th May 2010
In Access 2003 I have a report based on a crosstab query that displays the
total number of checks deposited by month to different banks for two years
and the difference between the current and previous year each month. I need
to know if there is a way to only display the montly data if there is a row
for both years. We only started tracking the data in April of 2009 so...
The Query data looks like this:
DepYr DepMoNbr BOA JPMC WllsFar DepMo
2009 04 3000 2624 1012 Apr
2009 05 2954 2326 1024 May
2009 06 3004 2459 1063 Jun
2009 07 ~~~ etc. up to May of 2010
2010 04 3583 2789 1193 Apr
2010 05 3548 2753 1127 May

The report looks like:
DepMo DepYr BOA JPMC WllsFar
2010 1234 2345 3456 Detail row
Jan 1234 2345 3456 DepMoNbr footer
2010 4567 5678 6789 Detail row
Feb 4567 5678 6789 DepMoNbr footer
2010 2341 3452 4563 Detail row
Mar 2341 3452 4563 DepMoNbr footer
2009 3000 2624 1012 These two rows are in the Detail
2010 3583 2789 1193
Apr 583 165 181 DepMoNbr footer
2009 2954 2326 1024 These two rows are in the Detail
2010 3548 2753 1127
May 591 427 103 DepMoNbr footer
2009 1234 2345 3456 Detail row
Jun 1234 2345 3456 DepMoNbr footer
2009 1234 2345 3456 Detail row
Jul 1234 2345 3456 DepMoNbr footer
~~~ etc. thru the end of 2009.

I want to display only the rows where both years are present.
DepMo DepYr BOA JPMC WllsFar
2009 3000 2624 1012 These two rows are in the Detail
2010 3583 2789 1193
Apr 583 165 181 DepMoNbr footer
2009 2954 2326 1024 These two rows are in the Detail
2010 3548 2753 1127
May 591 427 103 DepMoNbr footer

Sorry this is so long and thanks in advance for any help!
 
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
If / Then based off conditional format =?Utf-8?B?YmlsbCBjaA==?= Microsoft Excel Programming 5 1st Mar 2007 11:23 PM
Conditional format records? =?Utf-8?B?TmV3U3lzQWRtaW4=?= Microsoft Access Forms 1 11th May 2005 10:26 PM
Conditional Page Break based on number of records =?Utf-8?B?cGFyaXNoYWRtaW4=?= Microsoft Access Reports 0 25th Oct 2004 08:45 PM
Using conditional sum to calc. based on format Matt M Microsoft Excel Worksheet Functions 1 5th Apr 2004 06:14 PM
Conditional format based on format of another cell Jason Microsoft Excel Worksheet Functions 4 23rd Jul 2003 10:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:34 AM.