Recent content by Tommy888

Thanks that works correctly now ;).

Option Compare Database Private Sub btnNewRace_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("tbl_Race", dbOpenDynaset) rs.AddNew !RaceName = Me.txt_RaceName !Season = Me.lst_Season !SchemeID = Me.lst_SchemeID rs.Update rs.Close Set rs =...

Hi, In essence what I am trying to do is to create a lookup in SQL that will look at two fields in a query (qry_RaceResultsWithRankandRaceType) the fields are Rank and SchemeID. Then the lookup will look into the table (tbl_PosistionPoints) and find a record where Posistion is equal to rank and...

Thanks, this looks like it will work, I keep getting a syntax error when I come to run it though. Ive tried but cant find the reason why it wont work? (missing operator) in query expression". It then highlights qry_GameResults.[Player Rank] = tbl_PositionandPoints.Position Select...

Hi, I have a query that contains two fields that are used to calculate points from another table and add a new field in the query called GamePoints. Here are the relevent entities: qry_GameResults PlayerID Player Rank GameID GameTypeID GamePoints tbl_PosistionandPoints GameTypeID...

Thanks for your time, thats worked perfectly. :)

Thats great Banana, unfortunatley Im having a error when I come to run it though. I just made a quick query to check it out (as a append query type) and put in the code, now it has the error 'Syntax error in PARAMETER clause.' Any ideas why it would be doing this?

Hi, What I essentially am trying to do is to select a group that contains players, then assign that group to a game, the players will all then be assigned using a seperate entry ID to the game instead of one group entry ID, reason being is that each player has their own respective result. In a...

Ok well, I'm short on time but I can quickly tell you how to sum up the amount of lessons in a day, use a query that looks at the lessons for that day and use some SQL like 1st Query (rough SQL) Select Horse_ID Where 'Date of Lesson' = [Input Date] 2nd query, querying the first query...

Hi, I'm making a database for a local remote control car club, What I want to do is to automatically assign points to drivers based on their posistion and different points schemes. For example in Point sceme 1, there would be 5 points for coming first, 3 points for second, 2 points for third...

Hi guys, Hopefully you can help me with this. I have the following data which I have normalised into what I beleive is 1st,2nd and 3rd normal form. The Problem occurs for me (I think) when I get to third normal form, as you can see I make a new table (RaceEntry) with a compound key comprised...

Hi, Ok so I struggled to describe the problem in the thread title so I'll explain it in more detail here. I am making an access database for kart race scenario. The drivers can register for races and track their results for a particular race or agregate races. A driver can have points allocated...