Search results

I have a combo box on form which displays three game types (1-Divisional Trophy 2-League Cup 3-League). What i need to do is based upon the selection of 1&2 i want it to allow access to another combo box. The other combo box will display a list of rounds qtr,semi-final etc. However the list of...

I need to update a field within one table based upon a value from another. The problem is after i have setup the relationships the field i need to update will not work. I have enclosed a screen shot of the relationship and field layout. I need to update the field" registered with"(tblhistory)...

I have created a query to display played records assigned to each player. From this i have then created a cross-table query to display ,by date across the page , the records for each player.(example attached). 1-Is there any way i can allow the user to select the date header by a range of...

I have a form which includes an unbound text box to enter details for a search.I also have a combo box which displays the specific info based upon the search. Is it possible to 1-When the information is entered in thesearch box to have the comb-box automatically display the drop-down list...

Please help I have a cross-table query wherby it displays each player and the corresponding dates they have played a match. The Played Date field is used as the column header. Where a record is found for a particular player having played on a specific date it enters a 1 beneath the column...

I have a problem displaying the total count of players signed to a club. I have two tables (tblclubs - PK=clubname)&(tblPlayers - PK=regid). A form has been generated to display each club. Within the form i want to total the number of players signed. At present i have tried to use DCOUNT...

Can somebody help. 1- Within the attached file is a screen shot of a report. I need the fields (game type and played date) to be displayed across the page. At most there will be 5 date values that will need to be displayed. player 1 header date1 date2 date3...

I have an issue updating a field in one table. The db consists of three tables at present (1-clubs 2-players 3-player history). When i add a player to the second table the field TEAMID (tb2) is updated with the teamID from table1. The problem i have is when a player history record is added the...

I have a problem with designing a report. I have three tables (1-clubs 2-players 3-player history). I need a report to display by club,then group by players assigned to the club ,the players history records. i.e club 1 - harchester united (clubs table)...