Discoverer: Comparing a sum with a fixed value

Hi,

[Quoted] I'm desperately looking for some help on this issue.

I've got a table which looks like this (simplified):

id	number(5)
date	date
account	number(3)
value	number(4)

Example:
39005	01.02.2001	100	700
39005	01.02.2001	900	25
40001	01.02.2001	100	713
39005	02.02.2001	100	925
39005	02.02.2001	900	95
40001	02.02.2001	100	856
40001	02.02.2001	900	30

Now I want to find out, where (which ID on which date) the values with account numbers '100'+'900' are together greater then 1000.

I already built up a Discoverer crosstable, where the sums of account 100 + account 900 are shown.

It looks like this:

date	id	100	900	sum
01.02.2001	39005	700	25	725
01.02.2001	40001	713	0	713
02.02.2001	39005	925	95	1020 <- This one!
02.02.2001	40001	856	30	886

But I don't know how to compare these sums with the fixed value of 1000.

Can you help me?

cu
Lars Reineke Received on Fri Feb 09 2001 - 10:56:25 CET