setting a number to a field which starts at 1 on a new day.

  • Thread starter Thread starter FBrnstrmr
  • Start date Start date
F

FBrnstrmr

So when I begin to add records on any given day the number of this field
starts at 1
and increments by 1 until I have finished entering records for that day. Any
suggestions on how to do that please? Thanks very much,
-Fred
 
So when I begin to add records on any given day the number of this field
starts at 1
and increments by 1 until I have finished entering records for that day. Any
suggestions on how to do that please? Thanks very much,
-Fred
Click to expand...

use DCount() and use the date as your criterion
 
Thanks Piet, I tried that [DCount(InspectionDate)] in both the Table default
field as well as the form default field but "the expression I entered has a
function containing the wrong number of arguments."
 
Well I figured that part out, but it turns out I need to DCount ased on 2
criteria, the date as well as the address location associated with the
record. How do I get the DCount to start a new count when I change the
location on the same date.
The location is in a form and the dcount # is in a subform of that form. as
are the Tables a parent child situation.
Thanks very much,
-Fred
 
Thanks Steve, I already have a timestamp which I am using for part of the
requiremenst but there is a location element as well. The subform is being
used to create records on a certain date and hence is time stamped but the
records of the subform are associated with the main form which tracks
addresses that means I need to number each subform record according to both
the subform date as well as the form's address. This means each time I change
the address I need the subform record numbers to be reset to 1 and increment
for each record added to the same address for that date.
 
Back
Top