Search results
-
M
Combine 5 text fields into one
Wayne you saved my day. Thank you so much for your help. -
M
Combine 5 text fields into one
Looking at this http://exchange.manifold.net/manifold/manuals/6_userman/mfd50Expressions.htm It seems like Len is the only reserved word? maybe I need to use the Char_Length(string), but that is very foreign to me. -
M
Combine 5 text fields into one
Line SELECT Table1![Line1] & Space(40 - Len(Table1![Line1])) & Table1![Line2] & Space(40 - Len(Table1![Line2])) AS table1![combine]; Typed that out wrong, but error is still present with the above. -
M
Combine 5 text fields into one
Wayne Thank you for your help this is what I have SELECT Table1![Line1] & Space(40 - Len(Table1![Lines1])) & Table1![Line2] & Space(40 - Len(Table1![Lines2])) AS table1![combine]; The other lines aren't there yet. I get the error "The SELECT statement includes a reserved word or an argument... -
M
Combine 5 text fields into one
Is this in the wrong area- or is this not possible? -
M
Combine 5 text fields into one
To rephrase I have this as an example SELECT (Table1!Lines) & (Table1!Lines1) AS Lines2 FROM Table1; BUT it does not keep the 40 characters for each field as spaces. it displays this goodgame when it should display good game ^ this is 36 spaces... -
M
Combine 5 text fields into one
Combine text fields into one - keeping input mask Hello, I am new to this forum and appreciate any help. What I have is 5 text fields(used to hold phrases), all 40 characters long - they have an input mask set up so that there are 40 " " (spaces) always in the field, or any thing you type has...