=[Field1] & "[","]" & [Field2] WHAT'S WRONG

[Garry]

I am using access 2007

I want to string [Field1] and [Field2] etc to actually print as follows

Roger","Jones or
Paul","Morgan

I have tried: =[Field1] & "[","]" & [Field2]

but without success

What is the correct format I should be using

Thanks in advance, Garry

 

[RoyVidar]

I am using access 2007

I want to string [Field1] and [Field2] etc to actually print as follows

Roger","Jones or
Paul","Morgan

I have tried: =[Field1] & "[","]" & [Field2]

but without success

What is the correct format I should be using

Thanks in advance, Garry

If you want the quotes, you'd need something like this

=[Field1] & """,""" & [Field2]