SQL select to display all records on a continuous report?

[AAAndy]

You are right, some of the fields have little spaces " "
Is there anyway to ensure that they are not there?

[pbaldy]

You can try using the Trim() function in the report's source query.

[AAAndy]

I added a new field and now nothing works, I get #Type!

plus when Macro button is hit to save gives error 3021

Does anyone know what that could be?

[pbaldy]

That's not much to go on. Can you attach the db here?

[AAAndy]

That's not much to go on. Can you attach the db here?

I figured out where the problem is, the problem is here, picture attached


When I remove the >>>> Not Like "Exclude"
then everything works

currently there is nothing in the Merger column

[AAAndy]

I figured it out. I made sure the entire column of Merge is set to No, and issue fixed

The fields still would not shrink so I put everything in one textbox

=([Addressee]+Chr(13)+Chr(10)) & ([Position]+Chr(13)+Chr(10)) & ([Organization Name]+Chr(13)+Chr(10)) & ([Address Line 1]+Chr(13)+Chr(10)) & ([Address Line 2]+Chr(13)+Chr(10)) & [City] & ", " & [State] & " " & [Zip Code]

[pbaldy]

Glad you got it sorted.