Syntax Error on Joining Fields in Report

rhounsome

Registered User.
Local time
Today, 07:59
Joined
Jul 16, 2001
Messages
36
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?
 

Users who are viewing this thread

Back
Top Bottom