Accumulating Dates

[blcknite]

Please could someone help me with my issue

i am creating a database for my boss at work and we need an accumulative time and i cannot seem to resolve the problem

i need it so if an item goes on hold for say 3 days comes off hold back into re-work but another issue arises and it needs to go back into the hold box then i do not loose the 3 days it has already been on hold. so if it is on hold the second time for 6 days my time on hold box will no longer say 3 days it will accumulate the 2 hold dates to make 9 days.

i hope this is clear enough for you to help me.

thank you in advance to anyone able to help me

[blcknite]

please is there anyone that can help i am yet to be able to resolve this problem after much time spent browsing forums and google i have found nothing, i am new to access and need to be able to do this


thank you to anyone who is able to help

[MAF4Fam6]

Consider the following suggestion:

The Table:

Attachment 463

- TotalDaysOnHold field is defaulted to 0

The Query in Design View:

Attachment 464

- Used a calculated field named DaysOnHold

The Query Running:

Attachment 465

- Notice how the record was previously in Hold status for a total of 3 days; the record was then placed in Hold status again on 19 Dec 09. Between 19 Dec 09 and today's date, the current DaysOnHold would calculate to show 7 days OnHold.

You may need to tweek the expression for the calculated field depending on how you want to count one Hold day.

RC
Fruit Heights, Utah