Guys new to the forum looking to learn some tricks and get up to speed quickly.
Here is my dilemma...
I have a table of contacts with mailing info and an account number that's one to many. There is no individual id on the file other than the autonum generated when I imported.
I want to select no more than 5 contacts per account number which I will output and mail. How do I limit my results to no more than 5 per account number?
Bonus.. I will want to use the above data to use to select the remaining names from this table. How would I go about doing that..?
Thanks
Eric