Search results

We have a database, created in access 2010, to manage a club’s membership records with each member having a specific membership number. The policy is to delete all details of any member who has not renewed after a specified period. I created a query that identifies members who meet this...

I have a Sum query analyzing show entries that reports as followsshow year (grouped by) Entrant (grouped by) Number of entries (sum) and sorted descending I need to select from this the "Entrant" and "SumOFnumber of entries" and "year" only the entrant with the highest number of entries in each year

Hi I have a database recording competition entry's and results. The competition has a range of numbered classes each of which is awarded first , second and third. Monetary prizes are awarded but values vary depending on class. I have created A table (classes) A table (Prizes) which records the...

I have been using access for many years but, apart from one days training, am self taught. I mostly used the built in functions and have done very little using code.