On May 22, 2008, at 7:49 AM, Steve Moore wrote:
Case (
Left(GetNthRecord ( Product ; Get ( RecordNumber ) ) ; 1) ≠ Left
(GetNthRecord ( Product ; Get ( RecordNumber ) - 1 ) ; 1 ) ;
"<Heading>¶" & "<B>" & Product & "<B> " & PageNum & "¶";
"<B>" & Product & "<B> " & PageNum & "¶"
)
Yes, this will give the same results and does seem less evasive,
although I believe the result he needed was a bit different from the
email. She may have figured this out already:
Case (
Left(GetNthRecord ( Product ; Get ( RecordNumber ) ) ; 1) ≠ Left
(GetNthRecord ( Product ; Get ( RecordNumber ) - 1 ) ; 1 ) ;
"<Heading>" & Upper ( Left ( Product ; 1 ) ) & "<end Heading>¶<B>" &
Product & "<B> " & PageNum; "<B>" & Product & "<B> " & PageNum
)
None the less, good stuff Steve ;-)
The SELF JOIN RELATIONSHIP could prove to be useful for other needs
like isolating groups, summarizing, etc... Of course, it is not
mandatory but no there no need to be too nervous about it ;-)
Don Wieland
D W D a t a C o n c e p t s
~~~~~~~~~~~~~~~~~~~~~~~~~
[EMAIL PROTECTED]
Direct Line - (714) 389-4026
Integrated data solutions to fit your business needs.
