Debbie
1. Create a view:
CREATE VIEW MAXJOURN (Policy,MaxJDate) AS SELECT Policy, MAX(jrndate) FROM
AHISTORY GROUP BY Policy
In the report:
vjrndate = MaxJDate from MAXJOURN where policy = policy
David Blocker
----- Original Message -----
From: "Schooley, Debbie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 12:38 PM
Subject: Max Value for a Variable
> I am trying to get the maximum value for a variable that is being listed
on
> a report. The variable is not a column in the driving table it is a
column
> from another table. When I define the variable as:
>
> vjrndate = max jrndate from AHISTORY where policy = policy
>
> the response that I am getting is 12/31/4000 in all cases
>
> When I try the same request from an r> prompt, I receive the correct
> response - the maximum value for that column for that policy
>
> r> select max jrndate from AHISTORY where policy = policy
>
> Is there any way that I can get the maximum value to show up in the report
> for a column which is not actually on the table that the report is driven
> from?
