SQL in Access Queries

[Warrio]

Hello,

I have a field in a table. I'm using a query to Concatenate two Fields and
want to show the result as in a Memo (all together and not separated
records)

My code is

Select [No] +": " + [Note] As Notes
From Table 1;

What code can I use to see all the results concatanated in one field?

Thank you

 

[Albert D. Kallal]

Hum, need a bit info here.

when you say "all values" do you mean the whole database table?

I would think using a listbox if there is not too many entries would be much
easer.

You could also use a continues sub-form to show your sql also.

Did you want each "notes" field to be displayed as a separate line?