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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Way around using MEMO fields in formulas??
- Thread starter woolade
- Start date
synapsevampire
Programmer
Sure, create a SQL Expression that extracts the first 10 characters, then you can use the SQL Expression in formulas.
Insert->Field Object->Right click SQL Expression and select New.
Enter something like SUBSTRING(table.field,1,10)
This is database dependent, check the available string functions, or use the SQL for your database (I would have tried to supply the exact syntax had you posted your database type).
-k
Insert->Field Object->Right click SQL Expression and select New.
Enter something like SUBSTRING(table.field,1,10)
This is database dependent, check the available string functions, or use the SQL for your database (I would have tried to supply the exact syntax had you posted your database type).
-k
- Status
Similar threads
- Locked
- Question