Get max value in access or sql

Question

Manmohan Jha · Answer

I've solved this myself...Access Query is :- SELECT Max(Val(receipt_no)) AS rcptno FROM Receipt

Manmohan Jha · Answer

I use this query multiple time, but not work in accessi also use:-Select max(Cast(receipt_no as int)) From ReceiptBoth not working in access dbWhy???/

Chris Anderson · Answer

You need to convert your nvarchar datatype to int before calling max function. The working query given below:Select max(Convert(int,receipt_no)) From Receipt

forum

Get max value in access or sql

Can you answer this question?

3 Answers