Recent content by mitch97144

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...

query issue I have now managed to create a cross-table query that will display correctly , per date , when a player has played a match. Thanks for your information : :cool:

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...

query issue Thanks the zero dateplayed records no longer appear. An example of the query when run. ClubName RecordID RegID Salutation GameType Date Played A ----------------------------------------------------------------------- mufc 4 1256 Fred Smith Divisional Trophy...

query issue I have now managed to display a P against all records using the following criteria A: IIf([Date Played]=True,"P",[Date Played]) How do i remove the blank "Date Played" records from the query. I do not want these displayed. :)

query issue I have used the following command in the query IIf([Date Played]=[ddmmyy],"P",[Date Played]) I understand that where i have used [ddmmyy] it asks me to key in a date .Once keyed in it is displaying the record ,with the entered date, as a 'P' What i would like to do is where a...

cross-tab query I have tried setting this within the query and against the field on teh report and it does not work. Please advise

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...

cross table report Thanks for the advice i have now managed to create a cross table report. I do have three questions though and i have attached an example of the report 1-Where the digit1 is displayed on the report ,can i get this this to display as a capital P (for played). 2- Moving on...

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)...