I'm looking to print a number of labels, but only for unique items. I have my Run table which lists all the dogs that are running in a trial. I want to print labels for each dog, but sometimes dogs are entered into more than one run in a trial. I only want to print one label per dog no matter how many trials they are entered in.
I would usually use a Perform Find, but it looks like I cannot Find on a Distinct or Unique value. I've been googling and trying to find a solution but I don't really understand. I guess I could do it with SQL, however, I'm not sure how to get the SQL result value to be the only fields that show in my Labels Layout.
I'd love some help... I thought this one was gonna be easy but it's proving otherwise.