Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in fetching the single field

 
Dhiraj Srivastava
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks jamie
I will try this and then mail
dhiraj
 
Dhiraj Srivastava
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic