I want to have a field in my table/form (cust order) where it will automatically enter the date and a count for each order process on that date. Then on the next date it starts with a count of (1) again.
Something like this: Orders processed on 6/28/05 1st order of the day: 0628200501 2nd order of the day: 0628200502 and so on On the next day it starts with a count of one again. Order processed on 6/29/05 1st order of the day: 0629200501 2nd order of the day: 0629200502 3rd order of the day: 0629200203 10th order of the day: 0629200510 Any suggestion on how to do it would be very appreciated. Carlos and so on ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hb6eu30/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122705181/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
