Change display of query output

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 26 May 2005 01:52 GMT

Any ideas how to display out from query below

qry02StrategicGoals02 SG AboveBelow CountOfAboveBelow
1 Above 254
1 Below 30
2 Above 141
2 Below 54
3 Below 2
4 Above 7
4 Below 4

into

SG Above Below
1 254 (30)
2 141 (54)
3 0 (2)
4 7 (4)

Please note that the "Below" values must change into negative numbers.

Signature

Thanks,
Tom

Reply to this Message

Van T. Dinh - 26 May 2005 02:54 GMT

Modify your current Query to show negative numbers for "Below" and then use
this Query as the DataSource for a new CrossTab Query.

See Access Help on CrossTab Queries.

HTH
Van T. Dinh
MVP (Acees)

> Any ideas how to display out from query below
>
[quoted text clipped - 16 lines]
>
> Please note that the "Below" values must change into negative numbers.

Reply to this Message