T
tgassmann
Hello,
I have a MS access database with 2100 rows of data. Each row has a
unique id called orgid.
Each row also has a numeric field called orgtype. Currently, there are
9 different orgtypes.
I would like a random non-repeating query that will select X number of
rows from each orgtype and copy all DB fields into a new DB table.
What I mean by non-repeating, when a organization is selected, it is
marked, so that it can never be selected again.
This is a time sensitive school project.
I am not very good at programming in MS Access, but I am a quick
learner.
Any help would be appreciated.
Thanks
Jlimited
I have a MS access database with 2100 rows of data. Each row has a
unique id called orgid.
Each row also has a numeric field called orgtype. Currently, there are
9 different orgtypes.
I would like a random non-repeating query that will select X number of
rows from each orgtype and copy all DB fields into a new DB table.
What I mean by non-repeating, when a organization is selected, it is
marked, so that it can never be selected again.
This is a time sensitive school project.
I am not very good at programming in MS Access, but I am a quick
learner.
Any help would be appreciated.
Thanks
Jlimited