I have a table (Name:"dates" Columns: "Month", "Year")
In query mode, if I choose the table above as the source, how would I create a field that would be a combination of the "Month" and "Year" Fields.
i.e. Insert this into a new field in query view----> MonthandYear: [Month]+""+[Year]
In other words how do I make the syntax above work?