Custom counter in a appended table

[yameen2011]

Hi friends,
i have a question that how can i make a custom counter in a table where records are appended from another table.
i have already used custom counter method in my database before by using this technique.
http://www.599cd.com/tips/access/incrementing-your-own-counter/

but i want to make counter in a appended table.
regards.

 

[Cronk]

What do you mean by an "appended" table?

A linked table?
A table imported from another database?
Records imported and appended to an existing table?

If you want a seqential number to be applied to each record as a counter, then you could use an Autonumber field.

 

[yameen2011]

thanks for reply,
I want a custom counter in a table where records are entered through append query from another table.
I have these two tables tblGeneral_Ledger_Transaction and tbl_Fee_Transaction , both table hold all the transaction and i have another table tbl_Journal and in journal table hold all the entries from tblGeneral_Ledger_Transaction and tbl_Fee_Transaction.
When entry made in tblGeneral_Ledger_Transaction this entry also show in tbl_Journal through a append query and same for tbl_Fee_Transaction, it is also shows in tbl_Journal throug append query.
Now in tbl_Journal i have Journal_ID that is Auto Number field and i want here another auto number field (Custom Counter).

 

[Cronk]

Is is just a sequential number that you want to store in this second autonumber field? Why not use the existing Autonumber field.

I am failing to understand why you would want a second autonumber field.

Even Access can't see the point in having a second autonumber field because table design prevents having more than one such field.