t***@gmail.com
2018-08-09 19:31:49 UTC
I am a relative beginner in access, but can usually find my way around pretty good. However, i have been having trouble with this one. I am trying to get a query to pull back all records that contain a partial telephone number. For example, if i know a number is 5551212, i want the query to pull back everything that shows 14045551212, 17065551212, etc... along with the additional info in the table for that number. The user has a table where they can put their number in, click a button to run the query and pull back the complete number. Right now, you have to know the 10 digit number to pull back the data in the other table. I am trying to allow them to just be able to put in a partial number. The enter a number table is joined to the data table. I am sure this is a simple solution i am just missing, so any help would be great.