I have a report that shows employee injury data (body part injured & date) presented in List Boxes placed around an image of a human figure. TblBodyPart contains an autonumber column "BodyID" and a body part i.e. "Shoulder". QrySafetyFigure pulls data for a given date range. The List Boxes have a row source of:
SELECT [QrySafetyFigure].[EDepartment], [QrySafetyFigure].[DateOfInjury] FROM QrySafetyFigure WHERE ((([QrySafetyFigure].[BodyID])=37));
which works fine. Question: is it possible to group body parts i.e. "left" shoulder (BodyID=36) and "Right" shoulder (BodyID=37) in the same List Box?"