Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    NJ, USA
    Thanked 0 Times in 0 Posts

    Getting checks from text (Access03)

    I have a form where I set criteria for depart, credentials, and classes using listboxes. The reports can be further limited by date restrictions. What I want to be able to do is create a report that will put the different class names across the top, staff members names down the left side. The final need is for a check to be placed under a class name(s) if the individual staff member has taken one or more of the classes. Such as

    AccuData Basic EKG Patient Identification
    Jim X X
    Jane X X X
    Judy X

    How do I get the class names across the top and get the Xs?

    Thank you. Fay

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Melbourne, Australia
    Thanked 27 Times in 27 Posts

    Re: Getting checks from text (Access03)

    Try a crosstab query, or build a temporary table.

Posting Permissions

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