Results 1 to 6 of 6
  1. #1
    shoftware
    Guest

    Access Reports (A97 SR2)

    Is it possible to format a report thus :-

    Nurse1 Nurse2 Nurse3
    Patient Patient Patient
    Patient Patient Patient
    Patient Patient Patient
    etc

    The report is data comes from a query, basically "Select nurse, patient Order by nurse"

    Any ideas ??

  2. #2
    Lounger
    Join Date
    Jun 2001
    Location
    Syracuse, NY
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Reports (A97 SR2)

    Yes it's doable, but a very difficult report to format and one that's not very flexable as the the horizontal space limits the number of nurses that can appear on the report.

    You'd need to fill in a few more details before I would suggest a method for doing this. For example, is this a horizontal snaking format? i.e.

    Nurse1 Nurse2 Nurse3
    Patient Patient Patient
    Patient Patient Patient

    Nurse4 Nurse5 Nurse6
    Patient Patient Patient
    Patient Patient Patient

    Nurse7 Nurse8 Nurse9
    Patient Patient Patient
    Patient Patient Patient

    But the real question is, why would you want to. Your fighting natural report design all the way. If you outline what your trying to accomplish, there my be a better approach that someone could suggest.

    Jim.

  3. #3
    shoftware
    Guest

    Re: Access Reports (A97 SR2)

    Thanks Jim

    Your format is what I'm after.
    This report is to replace a manually produced word document from an old manual system which I'm replaceing.
    Just how difficult is it ?? I've tried to explain this to the client but they are very "clear" about what they want !!

  4. #4
    Lounger
    Join Date
    Jun 2001
    Location
    Syracuse, NY
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Reports (A97 SR2)

    Fairly difficult. I can think of two ways to do it, neither very attractive and I probably can come up with a few more.

    Try and talk the client out of it. You'd be doing them a favor. The report will waste paper (ie. Nurse1 has more patients that 2 or 3 leaving lots of white space) and be more difficult to read. Also, if additional info is required in the future, it would be difficult to modify the format.

    They really need to avoid taking the "spreadsheet" approach to report design. The two don't mix.

    Jim.

  5. #5
    shoftware
    Guest

    Re: Access Reports (A97 SR2)

    My feelings exactly....
    the only problem is the client also happens to be my Wife !!!
    wish me luck

    thanks

  6. #6
    Lounger
    Join Date
    Jun 2001
    Location
    Syracuse, NY
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Reports (A97 SR2)

    Oh no....the really tough sell<g>.

    Jim.

Posting Permissions

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