Hoping someone can help me out here . . .
I have a table that contains a number of records. It has two fields, "Starter" and "Main Course". Typical data would look like this. . .
Starter�Main
Soup, Beef
Soup, Chicken
Salad, Pork
Soup, Beef
Salad, Chicken
Soup, Beef
Salad, Pork
etc . . .
I need to try and select all similar pairs that occur in the table more than once. For example, in the above table, I would be looking to select Soup and Beef and Salad and Pork as they occur more than twice.
Anyone help?
I have a table that contains a number of records. It has two fields, "Starter" and "Main Course". Typical data would look like this. . .
Starter�Main
Soup, Beef
Soup, Chicken
Salad, Pork
Soup, Beef
Salad, Chicken
Soup, Beef
Salad, Pork
etc . . .
I need to try and select all similar pairs that occur in the table more than once. For example, in the above table, I would be looking to select Soup and Beef and Salad and Pork as they occur more than twice.
Anyone help?