Selecting All Numeric Values With Query String

Question

What seems to be a simple question that I can not find the answer to. I have a form where if the user enteres values I want to return those values  if they do not enter a value then return all. ex: area code [973] - return all (973) or area code [ ] - return all area codes however with a numeric field specified in the Access database it seems you can not have a string like query = select * from tablename where areacode = *; how would i return all for a number without doing something like where areacode > 0 and areacode <1000? Thanks

miker · Answer

Do you have areacode field in your Access database? If yes why can't you use Select areacode from myAreacodeTable. If you have duplicate values in this field use DISTINCT keyword.