Dont show duplicate field values

[Homegrownandy]

Im importing data relating to staff hours and staff miles.

These are then put on a PO for invoicing on two seperate lines.

This means each member of staff can appear on my data twice. I only want to see their name once (if they have a related record within the criteria then the name displays).

I could simply filter by "hours" as you should assume that if anyones done some miles then they have done some hours. But on the off chance someones claiming for a previous week then I dont want to limit the results.

I have a few ideas how to do this via update querys but im wondering if this can be done at the query level (select Query). any help appreciated.

[aytee111]

Is this a report? Are the lines consecutive? If so, set the property Hide Duplicates to yes.

[Homegrownandy]

Its just a select query that ill use as a record source for a form that shows outstanding invoices. if I turn on unique records or unique values it does nothing as the record is unique. The member of staff it relates to (this name is in the query also) is the only "non" unique part.

[CJ_London]

you need to remove all the fields which stop making the record unique

[Homegrownandy]

just to explain the problem better.

table 1 has a 1 to many relationship to table 2.

I want to see all of table 1 records that have a related record. But I want to see them only once. I don't need to see any data in table 2 at this point.

Its probably something I've done 100 times before and simple. I'm not seeing it though right now haha.

[Homegrownandy]

Its okay. I can just do another query and group by name.. I don't know why that took me so long

Thanks both.