Search results

Thanks Pat, this is really helping me. If anyone is starting on their first major Access project, I can recommend the Access Bible as a comprehensive reference.

Thanks Pat, but I think I'm going to have to give up on this route. I think I'll try working out how to create a form where the user can specify the query the data comes from and then the fields used in either a pivot table or a crosstab. This would be done from a form. Is it worth me starting...

To simplify the problem: I need a system which can report on the numbers of employees, for example, of different races in different job roles. Then another crosstab of numbers of people with diasbilities in different job roles. There are six different fields which need to be put against job...

I need to generate reports that are based on crosstab queries. In total, if they were manually created, I would need 180 crosstabs. This is impractical, inflexible and bad design. And insane. There will be approx 18 different reports with 10 different crosstabs in each. The crosstabs have the...