By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

product code

P: 2
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.
Dec 26 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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)
Dec 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.