View Single Post
  #1  
Old June 7th, 2010, 07:11 PM posted to microsoft.public.access.queries
Jazz
external usenet poster
 
Posts: 53
Default Function of colon between table names when query in design view

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?