@NightWalker,
The syntax ranman256 used is for a column in a query, not an actual table.
Lets say you have two fields in a table - "LName" and "FName" and you want to use their name in a report. You would concatenate the first name and last name in the query , not add a new field in the table.
So in design view of a query you would add this to a column
Code:
FullName: FName & " " & LName
In SQL view it would look like
Code:
SELECT SomeField, AnotherField, FName & " " & LName as FullName
In ranman256's answer, he used the query design view syntax. However, there is a problem because the OP has a field name of "Name" and a field name of "Number", both of which are reserved words that shouldn't be used as object names.
What will be returned is the name of the table (Tbl.name). Don't know what the name refers to: Owner name, dog name, event name,....????
And probably I would add a space between "Number" and breed:
Code:
oneFld: tablename.[name] & "/" & table2name.[number] & " - " & table2name.breed
The brackets are needed to tell Access that they are field names, not keywords.
Replace "tablename" and "table2name" with the proper table names.