Hi,
Sorry for the slightly confusing title. I've taken the following critera from duplicate search query:
In (SELECT [Customer_id] FROM [Rental] As Tmp GROUP BY [Customer_id] HAVING Count(*)>1)
From what I understand the >1 means that any duplicates more than one will be vaild for the critera of the query.
How do I make the 1 a variable that can be inputted by a dialogue box?
Also I would prefer simpler solutions as I don't know how to use Access that well.
Thanks,
Marcus