Search results

Štef, are you still around? (or anybody for that matter) Well, everything works fine with these subforms with prizes. I have now nice querries like: All Nobel prize winners in chemistry etc. The querry I still have not been able to accomplish is: List the persons with multiple Olympic gold...

Hola Štef You're right. You're right. You're right. I've got Access2000. A first try with 100'000 prize records didn't slow down the scrawling of forms. It still advances 15 forms per second when I stay on the page down key. So I'm completely convinced of the normalization technique now and I'm...

Hola Štef. (hola is spanish for hello) Extremly nice educational work, I must say - thanks a lot Štef. The one thing that's new for me is subforms - and I like that very much. However in this way I will end up with a prize table of about, let's see - 6 Nobel prizes since 1901, Oscars, Hollywood...

Thanks Colin, I'm already very much at ease since you accept that I have a small problem with these prizes - and even more at ease that it aint got an easy solution. Indeed, your last comment comes close to my own thinking and while my old human brain would have no problem in sorting the Grammy...

Thanks Štef. You're right, I'm not quite a top shot at Database Normalization. Thanks Colin. Of course, with my unprofessional way I have much less data stored. And, I have no difficulties in extracting all Grammy winners with a query that states in the prize field [Como "*Grammy*"] (sorry...

I run a data base with famous people. Now, celebrities win all sorts of prizes. Therefore in a text field called "Prizes won" I put in strings like [without (#)] (1) Grammy1998, Oscar2003 (2) Bambi1985, Goya1992, Grammy2001 (3) Oscar1991, Grammy1996, Grammy2003 Which query would yield...