Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009

    Unanswered: Report List Box grouping

    Hi all,

    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?"

    Thanks for looking!

  2. #2
    Join Date
    May 2005
    How about:

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

  3. #3
    Join Date
    Mar 2009
    Thanks Nick. I discovered I could also use this:

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts