Quote Originally Posted by gmaxey View Post
jdelano/arnelgp

I am comparing the solutions you have both provided. I am in no position to judge or even comment on which is best. Only looking at them to see if I can possibly learn to fish rather that be fed fish. I can't really see why arnelgp's 3 query returns 3 records and his 4 query returns 5. jdelano, in how would your query be modified to return the same result as arnelo's query 4?

Second question. The concept of "Normalization" is a cloudy one as well. Would either of you care to comment if you feel this simple database example is "normalized"? Thank you.
We're entering the "too many cooks in the kitchen" territory. I'll back out. Neither is "better" per say, just different. Mine returns 3 because in the test DB I have, there are only 3 projects. arnelgp is supremely adept at Access and its idiosyncrasies. They'll get you where you need to be.

Sorry for the confusion.