the above query starts from 1 and then adds one to the next record. what i want is that how can i
set the starting value to another value like i want to pick this value from a table say tr_Num
i tried the following but it doesent seem to work
Dim strSQL As String
Dim asdf As String
asdf = DLookup("trade_number", "trade_number")
strSQL = "alter table mtm add column n counter (asdf,1);"