okitek
08-19-2002, 11:19 PM
Hi,
I have a Query with LastName, FirstName & Social as fields. Here is the situtation. If the person is added to the table and already has an entry I need a field to calculate that.
Ex.
Smith James 145-89-7485 TC1
Smith James 145-89-7485 TC2
Notice the TC changes.
Any idea how to set this up???
I have a Query with LastName, FirstName & Social as fields. Here is the situtation. If the person is added to the table and already has an entry I need a field to calculate that.
Ex.
Smith James 145-89-7485 TC1
Smith James 145-89-7485 TC2
Notice the TC changes.
Any idea how to set this up???