Search results

Very nice idea! I did however fix my problem. llkhoutx's suggestion of splitting the queries did the trick. My large database and several complex formulas are retrieved and claculated in under 1 second after changing the primary keys around. I actually feel my current table design works the...

Ah yes, I thought this might happen. I made a mistake on my sample database and forgot to mention it. Only about 30 out of 35 of my testinfo tables have the same fields and only 10 out of 35 of my test tables have the same fields. I've been designing in access for nearly 5 years now and...

One other thing. I've read some other articles and forum posts that implied that a good table design should not have a table max out the number of indexes by having 32+ relationships. Is there something else I should be doing or is this a special case? As of right now I would need to have...

Okay. Right now I need my query to calculate the avg, min, max and range for each test required for that particular report. How about having 1 query perform all necessary aggregate functions, then the main query pull all the right data? Will that increase performance or should I break it down...

Oops, here's the file.

Wow, thanks for the detailed reply. I have a bit of experience in access and I'm pretty sure that the problem can't be seen in the relationships window. I posted a modified 2000 version of your relationships that is very similar to my current setup. Basically, just imagine about 35 more tests...

Hi all! I'm having a problem finding a way to design my database. I'm making a database for the quality assurance dept. at a local packaging plant. They want a database to store all of their test data. As of right now, there are approximately 36 different tests and there may be an unknown...