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 - 15 Jul 2006 06:52 GMT
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
> Hi!
>
[quoted text clipped - 19 lines]
>
> Gregg