Re: Forms 4.5 and group by queries

Well, I'm not quite sure - but that hasn't stopped me before... (I don't have the books here...)

I've done some column overlays like this for fun non table item querys. database block with col1 and col2 for query mode. control block with col1, col2 and col3 for view mode. note that col1 and col2 of both blocks have the exact same properties, including x/y coordinates.
with the right trigger placement - what happens is when you KEY-ENTQRY(?) you are in the db block and it's displayed to enter values for the query. Upon KEY-EXQRY(?) you actually do a

    set control block cols to values in db block.     set control block sum column to sum of your query you execute in the trigger.

This seems pretty reasonable to do with the right trigger placement...

[stealth sig]

Mark Styles <news_at_lambic.co.uk> wrote in message news: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 Sat Dec 01 2001 - 01:47:32 CET