S
Shirley
I have a detail billing table that doesn't have a unique
number. The information of this table needs to be loaded
to a consolidated table every month. In order to do it
automated and make sure the same data will NOT be loaded
twice, I need to create a unique number for each record
and key it with other fields in consolidated table.
If I can do it in a query, I'll be able to do it using
VBS. But I have no clue how to do it...Any help is
greatly appreciated...
Thanks,
Shirley
number. The information of this table needs to be loaded
to a consolidated table every month. In order to do it
automated and make sure the same data will NOT be loaded
twice, I need to create a unique number for each record
and key it with other fields in consolidated table.
If I can do it in a query, I'll be able to do it using
VBS. But I have no clue how to do it...Any help is
greatly appreciated...
Thanks,
Shirley