I am looking at a field from a query that is in design view. Inside the
field are two field names from the same table which are separated by a colon.
For example, Old and New are both fields from tblReplace and appear like
this Old:New in design view. I believe the colon concatenates the field Old
and New into a new field when you change the query view to datasheet view.
Am I correct?
Also, in a completely separate question if you are looking at a query in
design view and there is a field in the (Field
row, a table in the (Table
row, and Group By in the (Total
row what function will the Group By option
perform when you change the query view to datasheet view?