Can you add group on forms

[hullstorage]

I have a form based on a query for jobs that have not been printed

Can you add some sort of grouping to the form or query as at the minute the form looks like this

please note that these all have a seprate job id and the only information
from the query i want to see is this

customer inv no
==================
joe bloggs 122
joe bloggs 122
alan smith 123
alan smith 123
jason king 124
jason king 124

would rather have like this
customer inv no
==================
joe bloggs 122
alan smith 123
jason king 124

 

[Rabbie]

Just change your source query for the form to include

Select Distinct

which will exclude duplicate records. The downside is that the query won't be updatable.

 

[hullstorage]

Just change your source query for the form to include

Select Distinct

which will exclude duplicate records. The downside is that the query won't be updatable.

how do i do this

 

[Rabbie]

Just open the query in SQL View and edit it so it starts Select Distinct. It should start Select at present.