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

[Angela M]

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

[Mariostg]

The concatenate operator is the ampersand (&)
Here is an exemple:

SELECT T1.JulianDateField & " " & T2.TextField as ConcatenatedField
FROM table1 T1, table2 T2
WHERE T1.id = T2.id