Search results

HillTJ I've attached a small example database which shows the Incident Form and Actions etc, as you can do this with only a few tables but use queries

HillTJ , I have found some example of incident reports see attached. Regarding actions you can use a query to make a subform and it would then be coded to be linked to the main form at all times. I have not worked this out yet how it is done, maybe someone out there knows how

HillTJ Let me have a think about it over the next couple of days as i may have something on one of my archive drives

HillTJ How detailed do you want the accident/incident reports and are you thinking of having an initail incident report as well

HillTJ I would like to give you some help with this if your interested

After a few errors, managed to get it working Thanks

I would like to create a query that will add the previous months figure as a cummulative total per month ie Jan 2250 Feb 3000 This would be 5250 March 2000 This would be 7250 and so on Any help greatly appriciated Thank