Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2004

    Question Unanswered: Control Source Issue

    Currently I have a table that provides a list of members with associations. Members can belong to many associations or none.


    auto# Member# association#
    1 258 2
    2 258 5
    3 259 1
    4 262 2

    (this example shows that members 260 and 261 do not belong to any association therefor a no assoicatoin name would be listed.) There is a table with the association names/abbreviations with their number.

    I am creating name tags in Reports. I can get the associations listed with each member but only as (example):


    What I need is:

    NCA, NCIS, NACES (with it left blank for null fields.)

    I need to write a script in the control source (or in a query) to do this.

    I hope this makes sense. Help is appreciated.
    Last edited by aks311; 09-29-04 at 00:39. Reason: new title

Posting Permissions

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