Hi, i have three queries, which contain similar data (data taken from the same records). These three queries are based around dates (>startdate and <end date etc.) I have a final query which selects all the data from these three queries and puts them in one query, the problem is that this query lists multiple occurences of the one record, is there a way to make it so that a record will only appear once in this final query?

Thanks

Hey Pauly

Have you tried adding "Distinct" or "DistinctRow" to your Select statement?

ie Select Distinct PersonID FROM ....

-Sean