 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2007many sort criteria for one group in access report
Within one group I have, let's say, a return that starts with "A" and "B and "C". if the value starts with "A" I want to sort by field [x] if it starts with "B" sort by field [y]... etc. Create a calculated field like this --- Sort_Field: IIF(Left([Z],1)="A", [X], IIF(Left([Z],1)="B", [Y], [Z]))  SignatureKARL DEWEY Build a little - Test a little > Within one group I have, let's say, a return that starts with "A" and "B and > "C". > if the value starts with "A" I want to sort by field [x] if it starts with > "B" sort by field [y]... etc. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.