Bit of vague subject title there...lol

Just looking for some ideas of how to finally finish the last or what I hope to be the last bit of work on my database.
I have records (Jobs) that will display a Job status of either Active, Assigned, cancelled or complete

Active = Nothing done, waiting to be given out
Cancelled = Job not required anymore
Assigned = Given to a tradesman to carry out the work required
Complete = Tradesman completed the work & costs have been entered into the Job


At the moment Complete is the last stage that the record will get to & if done correctly should have a money value linked to it either from Labour & material costs.

My problem is that each month I need to run a report of all the completed jobs that WILL NOT have any more costs added to it & then invoiced & closed for good

I'm looking for the best way to achieve this as I know that unfortunately when a job is marked off as complete it may take some time for the cost details to come in & it may be more than one entry as more than one tradesman can work on the same job for any length of time.

I'm trying to avoid a job appearing in one Months report then again the next if more costs are entered.

so this is my plan

I create another Status called Invoiced & when I run the report for all cost movement for that month it will then run an update query & change the status to Invoiced

I just need to find a way to prevent people from still adding costs to a job after it has been marked as invoiced.


Does this sound like a good idea or is there a better way?

thanks in advance for any replies to this thread :-)