Report List Box grouping

[tuxalot]

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 on the report have a row source similar to:

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?

 

[pbaldy]

Like this?

WHERE [QrySafetyFigure].[BodyID] IN(36, 37)

 

[tuxalot]

That's what I needed. Thanks for the quick reply.