I want to be able to count the total amount of times all “jobs” has had all “job type”.
Example: Job - “Contact Customer” is Job Type - “Enquiring”. If we get a hit the type will change from “enquiring” to “prototype” however I want to log that is was an enquiry permanently and count how many total “enquiring” we have had. Then I will be able to track on a graph how many “enquiring” has converted into sales or failures.


Here are my two linked tables. I have set up previously a counter to +1 every time the record “enquiring” had updated however my problem lies with when the job changed type it will still +1 on removal also.
Basically I want “If records is added, +1 to total”
thanks for any help in advance