I have someone elses table in MSACCESS that they want me to create a form for. The first column is a list of numbers inputted by the user that identify an ACTION. Call it Action# field. Problem is even though this action# is unique to each ACTION, the same action# can be in that column maybe more than just once since the same action may need to go through more than just one series of steps in the process.
When creating a form, I need to configure a query or such in a manner that it will consolidate those identical action#'s from the table. In other words, I don't want the user to have to go from record to record seeing the same action# more than just once.
Example of table:
action# description TO FROM
101 Recommend Memo Mike John
101 Recommend Memo John Pete
101 Recommend Memo Pete Gary
103 GSA vehicle asgn Dave Barbara
105 Reorder part Nick shelby
105 Reorder part shelby Glenn
106 Schedule meeting Diva Jackie
Group all same action#'s on a form or query. Easiest way to do this?
When creating a form, I need to configure a query or such in a manner that it will consolidate those identical action#'s from the table. In other words, I don't want the user to have to go from record to record seeing the same action# more than just once.
Example of table:
action# description TO FROM
101 Recommend Memo Mike John
101 Recommend Memo John Pete
101 Recommend Memo Pete Gary
103 GSA vehicle asgn Dave Barbara
105 Reorder part Nick shelby
105 Reorder part shelby Glenn
106 Schedule meeting Diva Jackie
Group all same action#'s on a form or query. Easiest way to do this?
