Simple dBase expression question

[greggggggg]

Hi!

I am a total novice, but trying to teach myself some tricks.

In Query, I know I can combine two columns of data with this
expression:

Cal.REF+Cal.NOTES

But I want to but a space, three >>> and a space between the data in
REF and the data in NOTES.

I thought I could do this with a statement like...

Cal.REF+" >>> "+Cal.NOTES

....but it doesn't work.

Any suggestions?

Thanks!

Gregg

[greggggggg]

Sorry, I meant to also say that when I type in Cal.REF+" >>>
"+Cal.NOTES or variations of this I get this error:

"Too few parameters. Expected 1".

Thanks for your help!!!

Gregg



greggggggg wrote:
> Hi!
>
> I am a total novice, but trying to teach myself some tricks.
>
> In Query, I know I can combine two columns of data with this
> expression:
>
> Cal.REF+Cal.NOTES
>
> But I want to but a space, three >>> and a space between the data in
> REF and the data in NOTES.
>
> I thought I could do this with a statement like...
>
> Cal.REF+" >>> "+Cal.NOTES
>
> ...but it doesn't work.
>
> Any suggestions?
>
> Thanks!
>
> Gregg