I currently have a table of information in access that I need to query certain fields with.
The issue is that I can not define a field length for the query's results.
Lname must have a field length of 30 regardless of use
TermHrs must have a field length of 3 regardless of use
I've tried left(), mid(), right(), substr()...and none of them have worked.