I’ve created a cross tab query that obtains the total of faults on any date inputted as part of an underlying parameter query – so far so good.
However I’d like to generate a chart that reveals the trend for such faults – the only way I can think of doing this is to somehow automate an append query to another table with the relevant date and fault total, looping through all dates for which the append query has yet to backup.
Is there something I’ve missed or will I have to resort to VBA? Any assistance would be appreciated.
However I’d like to generate a chart that reveals the trend for such faults – the only way I can think of doing this is to somehow automate an append query to another table with the relevant date and fault total, looping through all dates for which the append query has yet to backup.
Is there something I’ve missed or will I have to resort to VBA? Any assistance would be appreciated.
