Change display of query output

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

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.
 
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)
 
Back
Top