Jond0312
asked on
Define field length for query results
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.
For example:
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.
The issue is that I can not define a field length for the query's results.
For example:
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.
len()
try this:
Lname1: mid([Lname],1,30)
TermHrs1: mid([TermHrs],1,3)
jaffer
Lname1: mid([Lname],1,30)
TermHrs1: mid([TermHrs],1,3)
jaffer
ASKER
I tried
mid([Lname],1,30) & mid([Fname],1,30)
my results...
DerekKellgren
i need
Derek_____________________ ___Kellgre n_________ __________ ___
mid([Lname],1,30) & mid([Fname],1,30)
my results...
DerekKellgren
i need
Derek_____________________
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
for [Lname] and [Fname]
FullName:FormatText([Lname ], 30) & " " & FormatText([Fname], 30)
FullName:FormatText([Lname