-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Report
- Thread starter Buffy
- Start date
Corticus
Well-known Member
- Joined
- Apr 30, 2002
- Messages
- 1,579
Welcome,
I would use a querrie to look at whatever type of 'transaction' table you have. If you right click on the grey area around where the table is when the querrie is in design mode, your can select properties|Top Values and the set what values you want to look at. It will choose the top whatever percent based on the data in the leftmost sorted column of the querrie.
Set the recordsource of the report to this querrie.
HTH,
Corticus
(boy, answering stuff in here is hard...)
This message was edited by Corticus on 2002-11-26 08:29
This message was edited by Corticus on 2002-11-26 08:30
I would use a querrie to look at whatever type of 'transaction' table you have. If you right click on the grey area around where the table is when the querrie is in design mode, your can select properties|Top Values and the set what values you want to look at. It will choose the top whatever percent based on the data in the leftmost sorted column of the querrie.
Set the recordsource of the report to this querrie.
HTH,
Corticus
(boy, answering stuff in here is hard...)
This message was edited by Corticus on 2002-11-26 08:29
This message was edited by Corticus on 2002-11-26 08:30
Upvote
0
Similar threads
