Parameter Question

• mjbriggs03

  SSC Eights!

  Points: 928

  More actions

  April 9, 2012 at 9:24 am

  #254464

  Hello all,

  I'll try to make this short. I have several field reps assigned to several communities. So the data looks like this...

  Community Field Rep

  Boston Williams

  Melrose Williams

  Malden Riley

  Cambridge Franklin

  Lexington Riley

  Reading Franklin

  Stoneham Williams

  Wakefield Riley

  So I set up my parameter and navigate to the Preview pane. When I click the drop-down, I see Williams three times, Riley three times, and Franklin twice. I only want to see the names ONCE. Any tips?

• mjbriggs03

  SSC Eights!

  Points: 928

  More actions

  April 9, 2012 at 9:28 am

  #1470706

  Sorry everyone, nevermind.

  I simply had to SELECT DISTINCT on the parameter query. My bad.