VFP (FoxPro) is probably the best swiss army tool I have ever used. However, I am slowly moving away from it because -

a) The lack of enthusiastic Microsoft...

JACKO999 - PEBCAK is just AWSOME!! No one in our group heard it before but as developers and support group, it HTS or it Hit The Spot.

TA (Thanks Again?)

While looping is not a set oriented solution but I think that is what you are looking for at this time.

Here is a sample of a cursor with some dynamic...

Not knowing much about your data, I would still strongly recommend that you normalize your data in SQL and then copy the results to MS Access. SQL is a...

A direct way to do this is using the "distinct" qualifier, as in:

select distinct names

into newtable

from oldtable

if you have a lot of columns in the old table then you...

Here is a simple way to get unique zipcodes as well as the number of members per zip code:

Sample tables:

create table tbMembers

(Member char(1),ZipCode char(5))

insert tbMembers (Member,ZipCode) values ('A','11111')

insert tbMembers (Member,ZipCode)...