filtering query data

hi everybody

i'm trying to filter data returned by a query in a list box on a form. basically the gist is i have a table of data such as:

group1 ? task1
group1 ? task2
group1 ? task3
group2 ? task1
group2 ? task2
group2 ? task3

i want to query this data and present the data removing the duplicates. so the list box would show:

group1 ? task1
-----------? task2
-----------? task3
group2 ? task1
-----------? task2
-----------? task3

the lines representing an empty space in the cell of the list box.

been banging my head against the table for the last couple of hours but can't work it out. can i do this through an expression in the query?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories