hello I am developing a banking application ms-access as back end for my account no field in account opening form i have to fetch the last account no from the table in access but i am enable to do so please note again i have to select a table then account no coloumn by record set then the last entry from that coloumn I hope that u people can understand Thanks in advance Dhiraj
First of all, why are you using MSAccess for a banking app!? If you are using autonumber for your account number then why don't you use a SQL query: "select max(account) from banking_table" or add a timestamp field and use something like "select account from banking_table where timestamp_field = (select max(timestamp_field) from banking_table" not sure I totally understand your problem Jamie
Dhiraj Srivastava
Ranch Hand
Joined: Aug 29, 2001
Posts: 49
posted
0
thanks jamie I will try this and then mail dhiraj
Dhiraj Srivastava
Ranch Hand
Joined: Aug 29, 2001
Posts: 49
posted
0
Jamie Can I select the max entry by using record set but the return type is String then i have to convert it into the integer could u please guide me Thanks
0
