This is my query:
SELECT [name1], [name2], [mail_street1], [mail_street2], [mail_city], [mail_state], [mail_zip], [phone], [website] FROM [flat_list] WHERE (([mail_state] = 'NJ') AND ([rl] = 'x' OR [rs] = 'x')) ORDER BY [name1], [name2]
This is what I am trying to accomplish: [mail_street1], [mail_street2], [mail_state], [mail_zip] (Combine into one field).
I am working on a couple of assumptions right now. One being that when I use the 'AS' the Grid View will be smart enough to reformat itself to reflect the fact that there is data that used to be in multiple columns that is now one. Two is that the use of 'AS' is actually possible with this query. I am honestly quite lost as to how to implement the 'AS' to combine said data. Can someone provide some input on this? Thank you.