oohoo_u
asked on
How to get max value from table (Access 2003 vs VB.net 2005)
Dear Experts,
i have 1 table (tbl_reg) with 2 fields (reg_no, reg_name) in access 2003.
in VB.net 2005, i want to get the max value for reg_no.
pleas help, how to code this?
thanks!
i have 1 table (tbl_reg) with 2 fields (reg_no, reg_name) in access 2003.
in VB.net 2005, i want to get the max value for reg_no.
pleas help, how to code this?
thanks!
select max(reg_no) as MaxRegNo from myTable
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it should be worked