quiz, last nonblank

Marcinik, Roger roger.marcinik@analog.com
Thu, 15 Jun 2000 14:25:23 -0400


The MAXIMUM summary operation may meet your requirement.

> ----------
> From: 	Bob Comeau[SMTP:bcomeau@crossley.ca]
> Sent: 	Thursday, June 15, 2000 2:19 PM
> To: 	powerh-l@lists.swau.edu
> Subject: 	quiz, last nonblank
> 
> I am reporting a set of records which contains a field that may be blank
> because the related record was optional.  How can I define a field such that
> it contains the current value of the problem field if is there (not blank or
> empty) otherwise it will contain the last real value for that field
> encountered so far in the report.
> 
> 
> Bob Comeau
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.