Question about Business & Productivity Software
i have cereated a table and inserted into values for carddetails.
now i have a problem here is
when i enter only 6 digits from the above cardnumber i have to retrieve the data
So, are you looking for the query statement to get this info...
And, upon entering the 6th digit, your code will execute the sql query, such as:
SELECT cardnumber from <table_name> where cardnumber>='123456'
NOTE: replace <table_name> with the name of your table.
You might have to modify the statement depending upon how your calling it.
Check out more info at http://www.w3schools.com/sql/sql_where.asp
Hope this helps.
Posted on Feb 02, 2008
Tips for a great answer:
Oct 11, 2010 | Microsoft Office Standard for PC
Oct 28, 2009 | Microsoft Office Access 2003 (077-02871)...
Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...
Feb 20, 2009 | Microsoft Office Standard 2007: Windows
Jul 01, 2008 | Microsoft Office Access 2003 (077-02871)...
Jun 03, 2008 | Microsoft Business & Productivity Software
Dec 26, 2007 | Business & Productivity Software
Nov 14, 2007 | Business & Productivity Software
Oct 21, 2016 | The Business & Productivity Software
77 people viewed this question
Usually answered in minutes!