Search results

I dont quite understand what you mean. The thing that im looking to do now is display the latest 6 matches of each team and produce a report (such as the one I have for FULL tables - in the db attatched). For example, ...this screenshot was taken from Soccerway.com and displays the...

Ok, I managed to extract the last 6 games (either home, away or both), but the thing that bugs me is I had to specify the teams name to do so. For example, I used... ...to display the last 6 matches for Arsenal (either home or away). Does this mean I would have to create 19 more queries with...

Will do. Thanx Rabbie ;)

Hi m8, I've just been reading one of your threads here: http://www.access-programmers.co.uk/forums/showthread.php?t=121434&highlight=football ...and I was just wondering if you ever managed to solve your issues and complete the database? If you did I would appreciate if you could share it with...

Edit: first of all, sorry for the terrible thread heading. I meant to add it after I finish the main part, but forgot. Now I cant edit it :( Hi, im new to this forum and Access. Im trying to create a database of football (soccer) results, data from which could then be used to provide various...