Concatenation

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

I have a query that I am trying to concatenate more than
2 fields. This new field is set up as a parameter that
asks the user for a value that equals the concatenated
fields. I am able to concatenate 2 fields, but when I
add the third field, the result is 0 records, which I
know is incorrect.


Any ideas? Are there limits to concatenating or known
issues that need to be addressed?
 
Hi Andrea,

Is it possible that any of the fields are Null? This
often causes problems in query calculations but I don't
know if it would apply in your case.

Also, you may want to check closely to make sure that you
haven't accidentally added a double space, or a trailing
space, or something like that in your concatenation.

You may want to try temporarily removing the parameter to
see if the concatenation is working properly.

If none of those ideas help, try posting back with your
query sql and a sample of what the data would look like
and hopefully someone will be able to spot the problem.

HTH, Ted Allen
 
Back
Top