 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2008Group by a multiple fields in query
Can anyone help? I have a query that has 3 fields Employee Name, Position Name and Work Instruction Name. An employee is allocated 1 to more positions and each position has several work instructions to it. I wish to be able to group (if this is the right terminology) by name and position (nb. 1 name could have several positions). Any help woulb be great. Thanks > Can anyone help? I have a query that has 3 fields Employee Name, Position > Name and Work Instruction Name. An employee is allocated 1 to more [quoted text clipped - 3 lines] > group (if this is the right terminology) by name and position (nb. 1 name > could have several positions). Just what do you mean by "group" in this context? Please give some sample data and an example of the desired output. John What I wish to do is show an employee name by position and then show all work instructions for that person & position. Sample Employee Name Joe Bloggs Positions held: Cleaner, Factory Hand and forklift driver Work Instruction associated to positions: Task 1, Task 2, Task 3 What I wish to see is: Employee Name: Joe Bloggs By selected position: Factory Hand & associated work instructions: Task1, Task2 & Task 3 I hope this is enough information Thanks John for your assistance. > > Can anyone help? I have a query that has 3 fields Employee Name, Position > > Name and Work Instruction Name. An employee is allocated 1 to more [quoted text clipped - 6 lines] > Just what do you mean by "group" in this context? Please give some sample > data and an example of the desired output. > John > What I wish to do is show an employee name by position and then show all [quoted text clipped - 4 lines] > Positions held: Cleaner, Factory Hand and forklift driver > Work Instruction associated to positions: Task 1, Task 2, Task 3 You will need some VBA code to convert multiple records into a comma separated text string. See http://www.mvps.org/access/modules/mdl0004.htm for sample code. |
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
|
©2009 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.