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?

[DonRayner]

@tuxalot
You can OR your WHERE statement to select multiple BodyID's

SELECT [QrySafetyFigure].[EDepartment], [QrySafetyFigure].[DateOfInjury] FROM QrySafetyFigure WHERE ((([QrySafetyFigure].[BodyID])=37 OR ([QrySafetyFigure].BodyID])=36));

[tuxalot]

Hi DonRayner,

Thanks for the quick reply. I discovered I could also use this:

SELECT [QrySafetyFigure].[EDepartment], [QrySafetyFigure].[DateOfInjury] FROM QrySafetyFigure WHERE [QrySafetyFigure].[BodyID] IN(15, 16, 33);

Tux