Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query for first 3 Characters only.

Status
Not open for further replies.
chuckh70

chuckh70

Programmer
Feb 4, 2004
71
0
0
US
I have an access database, and one of the fields I need to filter and show only those records with 3 or less characters. Ie; most of the data would be 555-555-5555, but some are 555.. and those are what I need to see. how can you do this in access?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
162
dhookom
dhookom
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
150
monkeysee
monkeysee
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
166
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
174
TheresAlwaysAWay
TheresAlwaysAWay
datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
140
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top