append query problem

[Guest]

I'm using a append query that has one query and one table. one field from the
query is joined to the same type in the table. the problem is that the table
is accessing data via a ODBC connection to Oracle 8.1.7 and the field in the
query only has 25 char and Oracle needs 28.

How do I add the remaining three spaces to the query field?

 

[Rob Oldfield]

Not quite sure if I get the whole idea...but you could just add some space
characters onto the field... preferably by just using the Space function.
So if your original field is MyField then a calculated field of
[MyField]&Space(3) will pad it by 3 spaces. That's if you know that MyField
is always 25 characters....

....if not, then you could use [MyField] & Space(28-Len([MyField]))

 

[Guest]

Rob,

can this be done in the design view of a query on the field it self not in
the criteria is?

Not quite sure if I get the whole idea...but you could just add some space
characters onto the field... preferably by just using the Space function.
So if your original field is MyField then a calculated field of
[MyField]&Space(3) will pad it by 3 spaces. That's if you know that MyField
is always 25 characters....

....if not, then you could use [MyField] & Space(28-Len([MyField]))

I'm using a append query that has one query and one table. one field from the
query is joined to the same type in the table. the problem is that the table
is accessing data via a ODBC connection to Oracle 8.1.7 and the field in the
query only has 25 char and Oracle needs 28.

How do I add the remaining three spaces to the query field?

 

[Guest]

Rob,

I tried your Idea, I guess i doing something wrong it want work.

Let's see I'm trying to add spaces to a value coming from a query. when the
vaule from query 1 passing its value to query 2 its removing the 3 spaces at
the end. I need them to stay. How do I get it to leave them or add them back
before query 2 gets the value?

Not quite sure if I get the whole idea...but you could just add some space
characters onto the field... preferably by just using the Space function.
So if your original field is MyField then a calculated field of
[MyField]&Space(3) will pad it by 3 spaces. That's if you know that MyField
is always 25 characters....

....if not, then you could use [MyField] & Space(28-Len([MyField]))

I'm using a append query that has one query and one table. one field from the
query is joined to the same type in the table. the problem is that the table
is accessing data via a ODBC connection to Oracle 8.1.7 and the field in the
query only has 25 char and Oracle needs 28.

How do I add the remaining three spaces to the query field?

 

[Rob Oldfield]

It shouldn't be truncating. I just set up a table with a text field,
created Query1 that had a calculated field in it... [textfield1]&space(3)...
saved that.... created another query based on Query1.... and that had the
same spacing added to the end.

If it insists on doing it though... you could just add the spaces in Query2

Rob,

I tried your Idea, I guess i doing something wrong it want work.

Let's see I'm trying to add spaces to a value coming from a query. when the
vaule from query 1 passing its value to query 2 its removing the 3 spaces at
the end. I need them to stay. How do I get it to leave them or add them back
before query 2 gets the value?

Not quite sure if I get the whole idea...but you could just add some space
characters onto the field... preferably by just using the Space function.
So if your original field is MyField then a calculated field of
[MyField]&Space(3) will pad it by 3 spaces. That's if you know that MyField
is always 25 characters....

....if not, then you could use [MyField] & Space(28-Len([MyField]))

I'm using a append query that has one query and one table. one field

from
the

query is joined to the same type in the table. the problem is that the table
is accessing data via a ODBC connection to Oracle 8.1.7 and the field

in
the

query only has 25 char and Oracle needs 28.

How do I add the remaining three spaces to the query field?