Search results

Hi, no, plog provided a formula which my query already has for each individual record (see file attached to #12).

Hi, I'm pretty new to this, can you provide me an example of the vba that would call the query results and then work out the percentage change? Thanks

Not sure how your function would work in a report. I can get the correct values in the query as seen in the file attached. I now need to summarise the query results by instructor.

I've now attached cut down versions, hope that makes it easier to understand. Thanks

Hi, attached are 2 files, the evaluation data and the query data (some rows deleted). Note that I'm trying to present this in a report at a summary level by instructor. So it should show: Instructor Name | Before Score | After Score | % Change from Before Score to After Score. Hope that...

Ok no problem I'll send the data through tomorrow when I'm back online. Do you need the query that works out the percentage score for each record? I'm probably making this more complicated than it should be.

Hi, I'm new to this and I've created a report that shows evaluation scores before and after for some training we are delivering. The Query I've created works out the percentage of change for each record. The problem I'm having is that I can't now summerise these percentages for each...