• Getting checks from text (Access03)

    Author
    Topic
    #434419

    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

    Viewing 0 reply threads
    Author
    Replies
    • #1024081

      Try a crosstab query, or build a temporary table.

    Viewing 0 reply threads
    Reply To: Getting checks from text (Access03)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: