A
Azad,DH, BD
All Experts and my Gurus(Teachers),
Pls help me out from the danger. I'd like to calculate auto number in a
query. Suppose i'll dmax the serial number from the existing table then the
new serial will be by adding 1 with that dmaxed number. this is possible only
if i transfer 1 item. but i may transfer more than 1 item from a subdorm
datasheet view by selecting a checkbox at a time. Then all the items get the
same serial i.e dmax +1 becomes the serial for all the transfered item at a
time. thats why, i need a auto numbering calculated field that will be added
with the dmax number. that is,
id the existing maximum serial is 3 in the table then the dmax in the query
will find 3.
Query:
Dmax Auto Number New Serial: Dmax+Auto Number
3 1 4
3 2 5
3 3 6
3 4 7
3 5 8
How can I do this? Mind it , I'm not talking about tables auto numbering
field. Thia ia all about in an append query.
Thanx, salam, namaste and greetings from me in advance.
Pls help me out from the danger. I'd like to calculate auto number in a
query. Suppose i'll dmax the serial number from the existing table then the
new serial will be by adding 1 with that dmaxed number. this is possible only
if i transfer 1 item. but i may transfer more than 1 item from a subdorm
datasheet view by selecting a checkbox at a time. Then all the items get the
same serial i.e dmax +1 becomes the serial for all the transfered item at a
time. thats why, i need a auto numbering calculated field that will be added
with the dmax number. that is,
id the existing maximum serial is 3 in the table then the dmax in the query
will find 3.
Query:
Dmax Auto Number New Serial: Dmax+Auto Number
3 1 4
3 2 5
3 3 6
3 4 7
3 5 8
How can I do this? Mind it , I'm not talking about tables auto numbering
field. Thia ia all about in an append query.
Thanx, salam, namaste and greetings from me in advance.