High everybody<br>i want to make a request and i need help:<br>i have two fields number1 and number2 in a record<br>i want to search the higher number2 of a specific number1<br>my problem is how to search the higher number2<br><br>thanks for help !<br><br>pour ceux qui comprennent le francais et qui n aurait pas compris mon anglais<br><br>j ai deux champs numero1 et numero2 et je veux pouvoir chercher l enregistrement qui contient le plus grand chiffre dans le champ numero2 pour un numero1 donné<br><br>Merci par avance<br> <p>Raph<br><a href=mailto:rchene@rockefeller.univ-lyon1.fr>rchene@rockefeller.univ-lyon1.fr</a><br><a href= > </a><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
request and fields
- Thread starter ZeuBug
- Start date
jimmythegeek
Programmer
Paste this into the SQL view of a query changing the table name:<br><br>SELECT Field1, Max(Field2) AS Highest FROM <b>YourTable</b> GROUP BY Field1;<br> <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href= Application Development
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
