Carlos,
My sample db named AppendSequence might be of interest to you. It is
available at Rogers Access Library (other developers library). Link -
http://www.rogersaccesslibrary.com
You could adapt the underlying approach suitably, for your specific needs.
Best wishes,
A.D.Tejpal
--------------
----- Original Message -----
From: Carlos
To: [email protected]
Sent: Saturday, July 30, 2005 10:02
Subject: [ms_access] Date with an auto count
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
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hmhdemf/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122888951/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In
low income neighborhoods, 84% do not own computers. At Network for Good, help
bridge the Digital Divide!</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/
