I've put this small DB together that I hoped would be part of a larger application.
The problem I have is, it's slow.
The table where all the data is, IHS - Allowance Status by Project and Location, has 48K records when fully imported from Excel.
I've deleted most of them for the attached DB and even then it's bit slow.
I have a feeling that my approach in developing this is two complicated....??? Many queries, many subreports, …. etc.
If someone could take a look and let me know if there is a way to speed this up or if on suggestions on how to accomplish this another way, I'd be very appreciative.
Thanks
The problem I have is, it's slow.
The table where all the data is, IHS - Allowance Status by Project and Location, has 48K records when fully imported from Excel.
I've deleted most of them for the attached DB and even then it's bit slow.
I have a feeling that my approach in developing this is two complicated....??? Many queries, many subreports, …. etc.
If someone could take a look and let me know if there is a way to speed this up or if on suggestions on how to accomplish this another way, I'd be very appreciative.
Thanks