Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Access Developer" Newsgroups: comp.databases.ms-access Subject: Re: UK premier league database problem Date: Sun, 30 Mar 2014 21:12:40 -0500 Lines: 54 Message-ID: References: <7ov8id$5ek$1@news6.svr.pol.co.uk> <5929e8a7-89b6-4b6e-90d1-99da0b47ea46@googlegroups.com> X-Trace: individual.net kfsB36VyDO8Vho58SB88SQhyD5RrYWDeVMRX6neI+rA/ZkWSrV Cancel-Lock: sha1:13kXqNCE84kaGxgA0dBibMIsh0A= X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 X-RFC2646: Format=Flowed; Original Xref: csiph.com comp.databases.ms-access:9223 Hi, Chris... don't worry about a little delay of 14 or 15 years. Even those of us who contended that 97 was the best-ever release of Access (and some of us still so contend) have moved on by now. -- Larry Linson wrote in message news:5929e8a7-89b6-4b6e-90d1-99da0b47ea46@googlegroups.com... > On Thursday, August 12, 1999 4:30:00 PM UTC+9:30, Ruud Waterval wrote: >> Hello, >> >> I want to make a database in MS Access 97, in which I can enter results >> of >> the UK premier league football (or soccer). I am quite a newbie, but >> I've >> worked my way through. However, I still have a problem which I cannot >> solve. >> >> The problem is that I am not able to make a query, which produces the >> players of a home- or awayteam on the match-form. The match-form >> consists >> of a mainform and two subforms. The general matchdetails are filled in >> the >> mainform, and details of each player (eg. time played, goals scored, >> yellow >> card, etc) are filled in the subforms (one for hometeam and the other for >> the awayteam) . >> >> In the subform I want to choose the players from a listbox. It should >> only >> list the players of the home (or away)team of the match. The database, >> that >> I made sofar, shows all the wanted players, but also shows the players >> from >> previous matches (records). >> >> Does anyone know what the cause is? Who can help me? Which >> database-expert >> wants to have a look at my database? >> >> Thanks a lot, >> Ruud Waterval > > Hi Mate, > Sorry for the late reply. > If you send me your database I can take a look at it for you, try and see > if we can fix it up. > Cheers, > Chris