My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Trouble sorting in report
|
|
 Jan 12 2006, 11:07 AM
Post
#1
|
|
|
UtterAccess Member Posts: 27  |
Hello!
I have some trouble sorting in my report. The report is based on a question. How do I make a name which is occurring several times to be shown only once in the report? For example. "John Johnsson" is placed in two posts in a linked table. The report shows "payment = 1" for each post. I would like it to show just "John Johnsson" once and make "payment" to show "2" Current situation: John Johnsson 1 John Johnsson 1 Goal: John Johnsson 2 I hope I'm not to confusing here. All help is appreciated! Thank you in advance! / Martin |
 |
 
|
|
Jan 12 2006, 11:08 AM
Post
#2
|
|
|
UtterAccess VIP / UA Clown Posts: 25,021 From: LI, NY |
Group by the name and sum the payment. Set the Visible property of the Detail band to no. If you use the Report Wizard, you can select a summary only report.
|
|
|
|
|
Jan 12 2006, 11:08 AM
Post
#3
|
|
|
UtterAccess VIP Posts: 31,413 From: NC, USA |
You have posted this thread in multiple forums. Please post questions only to one forum. Double posting and cross posting does not improve your chances of finding a solution.
"Double Posting" and "Cross Posting" are not allowed here at UA; they only create confusion with the people that may try to help you. Please post your problem in only one forum and only once within that forum. |
|
|
|
|
Jan 12 2006, 11:21 AM
Post
#4
|
|
|
UtterAccess Member Posts: 27 |
Ok. Tried it. But if I set the visible propery to no. I do not get any information in the report. I just want to remove the duplicate.
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th May 2013 - 10:48 AM |