product code

jyotig

hi

software in ms-access

table name - company
field-product_code

i want this product code will be change depending on month.
if month is janury my product code is start from 0001, 0002,0003,0004....0011,0012........
but if month change then product code again start from 0001,0002,0003.....up to month end.

nico5038

Using "coded" codes is in general discouraged.
In this situation I would just use a "DateTimeEntered" field for recording the product and use a function to extract the YearMonth and calculate the sequence number.

Nic;o)

product code

re: product code

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about