H
Hell-fire
Hi,
Probably something very simple, but it eludes me.
I have query that sorts via field named [Reportorder] and [IDs], it has 15
other fields, but the first two I mentioned does the sorting.
When I do my report, it will first sort via [Reportorder] then by [IDs].
The problem is I don't want duplicates of any [IDs] to show up, just the
first [IDs]. Each report has its unique identifier which is field name
[Identifier].
At the moment when I do my query it will look like this:
Reportorder IDs
2 I0070
2 I0070
3 I0056
3 I0054
I don't need the second I0070 to show up. Is this possible? probably is so
simple, but I'm not experienced with making queries. So if you can help me,
please do and remember I'm still a newbie. Thank you.
Probably something very simple, but it eludes me.
I have query that sorts via field named [Reportorder] and [IDs], it has 15
other fields, but the first two I mentioned does the sorting.
When I do my report, it will first sort via [Reportorder] then by [IDs].
The problem is I don't want duplicates of any [IDs] to show up, just the
first [IDs]. Each report has its unique identifier which is field name
[Identifier].
At the moment when I do my query it will look like this:
Reportorder IDs
2 I0070
2 I0070
3 I0056
3 I0054
I don't need the second I0070 to show up. Is this possible? probably is so
simple, but I'm not experienced with making queries. So if you can help me,
please do and remember I'm still a newbie. Thank you.