trackdaychamp
Access Guy
- Local time
- Today, 14:44
- Joined
- Jan 22, 2007
- Messages
- 26
Hi,
I have a table called Strategic Programmes which has 2 columns "ProgNo" (unique ID) and "ProgName"
I need to connect to SQL Server from Access using connection and recordset objects to find the next highest "ProgNo"
What is the SQL query I need to execute to find the next highest ID number and how do I extract this from my recordset?
Thanks,
Mark
I have a table called Strategic Programmes which has 2 columns "ProgNo" (unique ID) and "ProgName"
I need to connect to SQL Server from Access using connection and recordset objects to find the next highest "ProgNo"
What is the SQL query I need to execute to find the next highest ID number and how do I extract this from my recordset?
Thanks,
Mark