M
Matt
I've got a table ('AutoNumb', 'Parcel', 'Size', 'Count', '#') with a list of
parcel numbers in one of the fields. Some of the parcel numbers have
duplicates. I added a field 'counts' that holds a count of the parcel
numbers.
Now, if there are three or more of a parcel, i need to number the first ones
as 01, the second as 02, the third as 03, etc...
I can run queries to make a new table ('Count', '#') with all record counts,
number these all "01", then all records where count is over 1, number these
"02", count over 2, etc.
I need to get the #s from the new table to the original table. Update query
will not work because count is the only related field. Is there a way to
automatically (VBA) copy the '#' field from new table to the old table? The
only way i can get the data over is highlight the entire column and paste it
into the table.
Thanks in advance,
-Matt
parcel numbers in one of the fields. Some of the parcel numbers have
duplicates. I added a field 'counts' that holds a count of the parcel
numbers.
Now, if there are three or more of a parcel, i need to number the first ones
as 01, the second as 02, the third as 03, etc...
I can run queries to make a new table ('Count', '#') with all record counts,
number these all "01", then all records where count is over 1, number these
"02", count over 2, etc.
I need to get the #s from the new table to the original table. Update query
will not work because count is the only related field. Is there a way to
automatically (VBA) copy the '#' field from new table to the old table? The
only way i can get the data over is highlight the entire column and paste it
into the table.
Thanks in advance,
-Matt