Record counter.

[Homegrownandy]

I'm making some changes to the structure of my database, Instead of each job having an install date, they will now be assigned days. Each day will have a date attached.



The problem right now is: some jobs require more than one day, usually when this is the case the 'days' are not consecutive. So from a scheduling point of view they must be treated as separate jobs. Although, they will always belong to the same job.

I've tried a few methods for achieving what I want with no success. So ill just post what I want and hopefully get pointed in the right direction.

In the new table I have made (called 'daysT') I need the 'day' field to represent what number day that is on that job.

Basically, if its the second day it should say 2. I need access to see that job 'x' has been assigned one day; then when I add a new one it's automatically '2' in the 'day' field.

this way I can track scheduling changes more accurately and provide more accurate billing reports.

On my form I want to have a button to add a day. Then a new record will be made with the day number auto generated. (I can then make a form to manage each day attatched to a job)

[ranman256]

access doesnt do record counters, so you either must enter it manually or just enter another datestamp. (which can later be counted)
the datestamp (date/time) will be linear and serve as a counter.

[Homegrownandy]

Ill go with a user entered title for that day if this is the case. Thanks.

[Homegrownandy]

http://www.techonthenet.com/access/f...eric/count.php

If you were interested ranman, I'm using this.