Table has a variable size filed. limit filed size to left 10 chara

D

Dan

I have a querie that returns based on a filed that is from10 to 20 characters
in size.
I want to limit the size to 10 characters left justified, but not hurt the
data in the main table. This will allow me to count the number of 10
character expressions used.
Any thoughts
Thank you
 
J

Jeff Boyce

Dan

Add a new field in the query definition.

Set it up something like:

NewField: Left([YourField],10)


Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Infopath file size exceeds the limit allowed and cannot be saved 0
Defining Text field sizes in destination Make-Table Query 3
adding new columns 0
Numbers & text 9
Importing MS Office Excel Comma Separated Values Files into a MSAccess 2003 database 1
Importing MS Office Excel Comma Separated Values Files into a MSAccess 2003 database 1
Query Exceeds the limit of data for a single record 7
Number of characters in a table name 11

Top