If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|