PC Review


Reply
Thread Tools Rate Thread

Autonumber associated with date

 
 
Majic
Guest
Posts: n/a
 
      21st Sep 2010
Hey guys,
I need your assistance please. if anyone has similiar code and would
like to share please do.

I have table called "tbl ChestLog" has EntryDate field that is set as
date() and another field called "Chest".
EntryDate format is mm/dd/yyyy and Chest is supposed to be a
combination of Julian Date based on the EntryDate and include -001
(autonumber based on date). For example:

EntryDate: 09/20/2010
Chest: 263-001 for first record for that date
Chest: 263-002 for second record for that date
..
..
Chest: 263-010 for last record for that date

EntryDate: 09/21/2010
Chest: 264-001 for first record for that date
Chest: 264-002 for second record for that date
..
..
Chest: 264-010 for last record for that date

I got the code to convert date to Julian date and added "-", but I
need help in autonumbering based on date and start new autonumbering
on the next date and so forth as it is shown above.

Thank you very much

Majic
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
change autonumber with date hpmarc@yahoo.com Microsoft Access 2 23rd Oct 2006 08:45 PM
autonumber and date =?Utf-8?B?R2VyYWxk?= Microsoft Access Form Coding 2 19th Dec 2005 05:07 AM
Autonumber with date included Yokim Microsoft Access Database Table Design 3 16th Oct 2003 02:08 AM
Autonumber and date??? Mac Microsoft Word New Users 1 18th Sep 2003 06:57 PM
Date and Autonumber Sondra Microsoft Access Database Table Design 12 20th Aug 2003 08:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:48 PM.