Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 04-24-2023, 10:49 PM
ArviLaanemets ArviLaanemets is offline Trying to sort different values from different categories under other categories Windows 8 Trying to sort different values from different categories under other categories Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Your design is not meant for getting info from your tables easily. Consider a design I applied as example of better one.

In Salaries Table, you preferably hide the column RecNo - it being visible only confuses user.

About getting info sorted, for easier cases you can use sort and filter options on Salaries Table. For more sophistcated cases, you can design report sheets, where proper Salaries Table RecNo value for report table row are calculated to hidden column in report table, and like on Entry sheet, this RecNo value is used to read wanted data from Salaries Table.
Reply With Quote
 

Tags
sort worksheet, table



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting: Sort Categories, and Then the Items in Each Category? tatihulot Word 1 05-12-2022 06:37 PM
Trying to sort different values from different categories under other categories Dynamic Categories stephen_ Excel 4 07-03-2013 01:38 AM
Categories disappear PattiL Outlook 0 08-05-2011 08:34 AM
Using categories Matelot Outlook 3 10-14-2010 07:32 PM
Categories disappeared? markg2 Outlook 1 08-02-2010 03:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft