By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

How to save 3 concatenated fields to one field in Access?

P: n/a
I'm trying to concatenate a julian date with a number and a text field that are located in 2 different Access Tables and can't find anything about it. Any help would be appreciated
Nov 8 '10 #1
Share this Question
Share on Google+
1 Reply


100+
P: 332
The concatenate operator is the ampersand (&)
Here is an exemple:
Expand|Select|Wrap|Line Numbers
  1. SELECT T1.JulianDateField & " " & T2.TextField as ConcatenatedField
  2. FROM table1 T1, table2 T2
  3. WHERE T1.id = T2.id
  4.  
Nov 8 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.