Forms 4.5 and group by queries

From: Mark Styles <news_at_lambic.co.uk>
Date: Fri, 30 Nov 2001 15:29:44 GMT
Message-ID: <f29f0uornbvf45fejgrig3bkphksct60fv_at_4ax.com>

I'm writing a query only form in Forms 4.5, and I want to create a block based on a summarised query, i.e. a group by query.

Here is an example of what I'm trying to do:

my table has the columns:

col1
col2
col3
dollar_amount

I want to be able to query by col1 and col2, but group the results by col3, summing dollar_amount.

The only way I can see to do this would be to create a temporary view or table on the fly, and then query off that view. Is there a better way? Received on Fri Nov 30 2001 - 16:29:44 CET