Recent content by steveflanuk

Just to give you an idea of what I am talking about. If you open up frm_main, you will see a subdatasheet listing the different surnames held in tbl_individuals (via the query qry_surnames). If you expand 'Bloggs' to see the 2 records in the nested subdatasheet, then you can see the current...

All I have a main form (frm_main) in which I have a subform as a datasheet (frm_sub1). In the first sub form I have a second (nested) subform (frm_sub_sub2) as a datasheet as well. On the main form I have an unbound text box which gives me the value of the ID field in the nested subform...

I have a database which I record soccer matches for a local amateur club. At the end of each season I create a document showing the details of all matches played during the season. The database is working well, but I am trying to enhance the report somewhat. The problem is around...

Hi all I have a query which provides data to a report based on a start and end date input by a user. Field = Date Criteria = Between [Enter Start Date] and [Enter End Date] When I run a report based on this query I get the parameter questions as I would expect, however...;) ...can I provide...

I would do, but the database is on a computer at the club, so I can't access it at the moment. Basically, I tried to do a crosstab query but it wouldn't allow me to provide the player and result for each individual rink (although it is highly likely I did something wrong!). Therefore, my...

Advanced apologies for the long question. I have a table providing a list of all members of a local bowling club, with the following fields - MemID, MemName (table is tblMembers) I also have two more tables providing details of matches we play in a local bowling league. The first table holds...