Selecting one instance

[petercummins]

Hi guys,

Still trying to get used to this Access lark.

A table contains a column with numbers i.e - 1,1,3,4,2,2,2,3,4,4

If i just want a query that shows one of each i.e - 1,2,3,4

what do i need in the criteria line?

Thanks in advance

 

[reclusivemonkey]

You need to click on the "Totals" button in your query design view (I looks a little like a capital E). That will group together all "like" numbers, so from your data you should get;

1
2
3
4

 

[petercummins]

Much appreciated....I will get the hang of it one of these days!