Find 7 Largest Numbers in 2 Fields

stahlwalker1929

Hi,

I am new to this and trying to get a report to run that finds the seven best times from two fields. I am creating a scoring database to be used for a tournament and each category has a Day 1 score and a Day 2 score. The problem I am having is getting a report that will just print one list with the top seven scores from Day 1 and Day 2 combined. For example Team 1 could have 30 pts day 1 and 20 pts day 2, while team 2 could have 25 pts. So the top three scores would be Team 1 30, team 2 25, Team 1 20. Does that make sense

May 14 '13 #1

Subscribe Post Reply

1115

Rabbit

12,516

Expert Mod 8TB

If they're in different fields, use a union query to normalize and correct your data structure. Then it's a simple matter of using a TOP predicate to select your top 7.

May 14 '13 #2

by: PHP2 | last post by:

do anyone here with more experience know where I can find largest Standard C++ library list? which URL is best source..

C / C++

find largest value in a column in DataSet

by: Jon | last post by:

hi, I would like to know is there a function in datacolumn that can get the largest value in a column in a dataset? otherwise what is the best way to do it? thanks, jon

Visual Basic .NET

finding largest numbers

by: ramu | last post by:

Hi, I have, suppose 1000 numbers, in a file. I have to find out 5 largest numbers among them without sorting. Can you please give me an efficient idea to do this? My idea is to put those numbers...

C / C++

Finding 1000 largest numbers from a file having some billion numbers

by: Subra | last post by:

Hi, What is the best way to find the 1000 largest numbers from the file having hell lot of entries ? Can you please help me to find out the way ? Do I need to go for B+ trees ?? Please help,...

C / C++

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics