Hi,
I have to select the Top 5 "Applicant Name" from a table( Detail) based on their Score AND Location.( Score & Location are field in my table) and copy the result in ms excel.
Can body help me with the code?
regards
Bony
Novice
Windows XP 
Access 2007
Hi,
I have to select the Top 5 "Applicant Name" from a table( Detail) based on their Score AND Location.( Score & Location are field in my table) and copy the result in ms excel.
Can body help me with the code?
regards
Bony
VIP
Windows XP Access 2010 32bit
Review http://allenbrowne.com/subquery-01.html
Look at example: TOP n records per group
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Incomplete Syntax Clause (syntax error)
UPDATE query syntax
query syntax or design help ....
Sql Syntax Query
Posting Permissions
Reply With Quote