Search results

I have tried this but could you give a bit more detail in what i need to do please as it does not seem to work, do i create two querys to start with please give more detailed instructions.

I have created a query called test this has all the players name is and results, Im trying to create from this query another query that will allow me to type in two different player names to compare there results. having bit dificulty doing this. see attached. Or would it be better with two...

Hi Could somone please figure this out scratching my head with it now On the Match Date form when I select Home for match type and then enter player name score then opp player Name and score it should auto populate with 2 points if its an away home win and 3 points if it is an away win per...

OK I apologise i didnt lol but it access 2010

ive tried before but the features I use do not work in any other version that access 2010 thats why I asked for access 2010 users.

unfortunatley not i used access 2010

Hi Could somone please figure this out scratching my head with it now On the Match Date form when I select Home for match type and then enter player name score then opp player Name and score it should auto populate with 2 points if its an away home win and 3 points if it is an away win per...

Hi My database has had an overhall, however I have noticed that the not in edit list now does not work for our player and opp player boxes. Could someone please have a look and put it right please. how it should work is when I enter 1st name and surname it should add them to the 1st name and...

I am using office 2010

I am using access 2010

I Really Need this resolving but am stuck. I have 3 combo boxes 1 called league type one called ourteams and one called opp teams When I select league Type it cascades the teams in our team to show the teams in that league, however i am unable to get the same cascading effect for the opp drop...

I Really Need this resolving but am stuck. I have 3 combo boxes 1 called league type one called ourteams and one called opp teams The cascading effect works for our teams but i cant get it to work for opp teams can anyone have a look and correct this for me please. When you select the league...

Hi I wounder if anyone can help with this. a friend of mine manage to create a cascade combo box on the data entry form, it works when you select leage type smethwick or south staffs it then shows in the our team combo box the teams linked to that division, however I have tried to copy the...

I have a form that I need help with the problem is this I have two team called langley B but each team plays in a different division. So in the form when I select either langey B team I want the div lable to auto populate to show waht division the team is in. could someone have a look at this...

Hi Realy Need help with this query. I have a query called query 1 that calcualtes the rank of each player by points, however instead of going 122356 etc i want it to go 112345 or if someone has the same points shows = as in =1st place. the tie break if two players would be plus.minus field like...

Hi i need an expression to rank the following query by points i.e points>points it should then put them in order 1st 2nd etc also the tie braker would be if someone has the same points then it would depend on the +_ value if the the players has both the same plus and points then they would be...

Hi Within the database below I have tried to create a multifield search form, however it only works when you use one of the drop down fields only, For example If i select home in match type it show all the home results, However what i would like it to do is the following As well as working by...

Here is the database in MDB File formate in zip folder hope someone can help

I ma trying to create the following database however I have now got this far but I am stuck as to why i cant enter the data and that the form has errors on it. I have also entered small amount of test data in the forms so any help in getting this to work would be great. 1 when I click on...