Created a Query that uses same field names, i.e Title, Forename and Surname.
The query handles this no problem. However trying to join the fields together and getting a syntax error. I believe the problem is the way Access views same field names but different forms.
Distributor.Title
Distributor.Forename
Distributor.Surname
The formula I have used is [Distributor.Title] & " " & [Distributor.Forename] & " " & [Distributor.Surname]
However you run the report and it views the formula like [[Distributor].[Title] & " " & [Distributor].[Forename] & " " & [Distributor].[Surname]]
How do I stop it from doing this?
The query handles this no problem. However trying to join the fields together and getting a syntax error. I believe the problem is the way Access views same field names but different forms.
Distributor.Title
Distributor.Forename
Distributor.Surname
The formula I have used is [Distributor.Title] & " " & [Distributor.Forename] & " " & [Distributor.Surname]
However you run the report and it views the formula like [[Distributor].[Title] & " " & [Distributor].[Forename] & " " & [Distributor].[Surname]]
How do I stop it from doing this?