Trincated query field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know similar questions have been posted before but none seem to help with
my problem.

I have a query:
"SELECT t_customer.produce_letter_date,
combine_text([t_customer].[customer_no]) AS letter_text
FROM t_customer
WHERE (((t_customer.produce_letter_date)=get_letter_date()));"

where "get_letter_date()" is a function that determines a date from a form
and "combine_text()" is a function that returns text from various other
queries. I know the "combine_text()" function returns the text in full when
run on its own but when I run it within the query it truncates to 255
characters. Can anyone suggest why or how to fix this.

Thanks
 
Maximum field size for a text field is 255 characters, but for a memo field
max size is over 62,000 characters. Try changing the field type to memo
 
Thanks for the reply Susan. "letter_text" is only an expression in the query
not a field in the database as I don't really want to store the result just
export it. How can I change this expression to a memo "field". Do I need to
create a field in Db for it?

Ian

Susan M said:
Maximum field size for a text field is 255 characters, but for a memo field
max size is over 62,000 characters. Try changing the field type to memo

ianc said:
I know similar questions have been posted before but none seem to help with
my problem.

I have a query:
"SELECT t_customer.produce_letter_date,
combine_text([t_customer].[customer_no]) AS letter_text
FROM t_customer
WHERE (((t_customer.produce_letter_date)=get_letter_date()));"

where "get_letter_date()" is a function that determines a date from a form
and "combine_text()" is a function that returns text from various other
queries. I know the "combine_text()" function returns the text in full when
run on its own but when I run it within the query it truncates to 255
characters. Can anyone suggest why or how to fix this.

Thanks
Click to expand...
Click to expand...
 
changing the underlying table fields to "memo" might work. I have no problem
getting queries to return greater than 255 characters from memo fields in
tables.

ianc said:
Thanks for the reply Susan. "letter_text" is only an expression in the query
not a field in the database as I don't really want to store the result just
export it. How can I change this expression to a memo "field". Do I need to
create a field in Db for it?

Ian

Susan M said:
Maximum field size for a text field is 255 characters, but for a memo field
max size is over 62,000 characters. Try changing the field type to memo

ianc said:
I know similar questions have been posted before but none seem to help with
my problem.

I have a query:
"SELECT t_customer.produce_letter_date,
combine_text([t_customer].[customer_no]) AS letter_text
FROM t_customer
WHERE (((t_customer.produce_letter_date)=get_letter_date()));"

where "get_letter_date()" is a function that determines a date from a form
and "combine_text()" is a function that returns text from various other
queries. I know the "combine_text()" function returns the text in full when
run on its own but when I run it within the query it truncates to 255
characters. Can anyone suggest why or how to fix this.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
I've solved the problem by writing the result of the function to a separate
table and then joining this table with the original table in the query. Your
right this returns more than 255 characters. There must be a limit set to
the legth of expression calculations as the original problem still exists
even though the underlying fields I'm querying are set to memo. Anyway
thanks for you help.

Susan M said:
changing the underlying table fields to "memo" might work. I have no problem
getting queries to return greater than 255 characters from memo fields in
tables.

ianc said:
Thanks for the reply Susan. "letter_text" is only an expression in the query
not a field in the database as I don't really want to store the result just
export it. How can I change this expression to a memo "field". Do I need to
create a field in Db for it?

Ian

Susan M said:
Maximum field size for a text field is 255 characters, but for a memo field
max size is over 62,000 characters. Try changing the field type to memo

:

I know similar questions have been posted before but none seem to help with
my problem.

I have a query:
"SELECT t_customer.produce_letter_date,
combine_text([t_customer].[customer_no]) AS letter_text
FROM t_customer
WHERE (((t_customer.produce_letter_date)=get_letter_date()));"

where "get_letter_date()" is a function that determines a date from a form
and "combine_text()" is a function that returns text from various other
queries. I know the "combine_text()" function returns the text in full when
run on its own but when I run it within the query it truncates to 255
characters. Can anyone suggest why or how to fix this.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top