I have Access XP and am having a tough time adding columns from different tables in a query. I have followed the Help file: ([column1]+[column1]+[column1]) after adding "column1" form three different tables. No dice.
What am I doing wrong? And if it's really dumb, don't laugh at me to hard
Thanks Brian
Hi.
The solution is not too difficult.
First it is always advisable to give your fields different names (All in design view). You do that by adding a new name before the original one like this:
Newname:Oldname
Then you must save your query.
Create a new field in the query by giving it a name, and then clicking the magic stick button open the formula builder dialog. The selected fields of your query appear in the middle. Just click each one of them twice and add the + mark between them.
When you're done, click OK and run the query.
The photo here is of a query with the same type and the dialog open with the fields selected.
Hope this helped.