Recent content by Mcp

While in design view of your query Select VIEW > SQLView Then type it in...

SELECT * FROM tblTesting WHERE RowA <> RowB; ??

I have found the problem.... Apparenty you cannot use Distinct on memo.....

Anyone know???

Consider the following... Select Distinct id, A & “ “ & B as Res From tblMain A is type text B is type memo Result cuts cut off at 255 Characters…. How can I get the entire result – More than 255 characters?? Thanks :)