Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 03-16-2019, 07:01 AM   #1
Newly Registered User
Join Date: Mar 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Binaarycode is on a distinguished road
Report that shows top score of each game

I'm currently making a database based around an internet cafe. I'm at the stage where I need to be able to produce a report showing the top score for each game available.

Currently I have a Member table with a primary key of Member ID
Software table with a primary of Software ID
Member game table - with Software ID, Member ID, Score,

I've been looking up top line queries(?) but I'm not sure this is the way I should be looking to do this?

any help is appriciated.

Binaarycode is offline   Reply With Quote
Old 03-16-2019, 08:43 AM   #2
Newly Registered User
June7's Avatar
Join Date: Mar 2014
Posts: 1,395
Thanks: 0
Thanked 340 Times in 339 Posts
June7 will become famous soon enough
Re: Report that shows top score of each game

If by 'top line' you mean TOP N, that is correct method.

Review http://allenbrowne.com/subquery-01.html#TopN
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Tables w/lookup - Report shows ID, query shows data mvanella Reports 1 11-15-2012 01:38 PM
Query shows Data but report shows ID # CTQE Reports 1 12-10-2010 01:20 PM
Report shows all possible values notfound Reports 3 09-05-2009 03:08 AM
[SOLVED] game golds here in the game thisaddress Macros 0 08-21-2006 07:58 AM
Show a pop up box when report shows null values returned John_Westham Reports 3 01-31-2005 05:24 AM

All times are GMT -8. The time now is 12:34 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World