Grouping in Access SQL

[rando1000]

I remember in the old days in FoxPro, I could create a distinct file based on a group number using the following code:

 Select * from myfile into myfile_unique group by myid order by myid

However, in Access, I generally have to do a dance each time, finding the non-unique values and pulling out one of the two (or more) by various methods, due to the fact that in Access I need to group by every field I name, and cannot "group by" with a wildcard in my Select.

Is there an quick way to do the above in VBA?

[NeoPa]

You may decide to add a further post to clarify the question.

I have very little idea what you're trying to ask.

Perhaps if you take the time to read what you've posted it may avoid this sort of thing in future.