I have A Query that is rather complex in that it combines 2 columns into one
field name  I.E:

SELECT DISTINCTROW Table1.Col1, Table1.Col2 & "," & Table1.Col3 AS MyCol,
Table1.COL4
FROM Table1
WHERE ((Table1.Col1 Is Not Null) AND (Table.Col5="AVALUE"))
ORDER BY Table.Col1
WITH OWNERACCESS OPTION;

the Problem is the CRW Data Browser and the Report itself return only one
character of the Column MyCol? When Run In Access this works Great. WHat am I
doing wrong? HEEEELLLLLPPPPP!
Thanx

--
               ////
              (o o)
---------oOOO--(_)--OOOo----------------

|      Big Foot Lives In the NW!       |
-----------.oooO------------------------
           (   )   Oooo.
            \ (    (   )
             \_)    ) /
                   (_/