Invalid Dot Operator

[Sprinks]

Access reports that the following is ambiguous because [StaffID] is a field
in both tables:

SELECT Staff.StaffID, [FName] & " " & [LName] AS FirstLast,
DMax("[PeriodBeginning]","TSHistory"," [StaffID]= " & [StaffID]) AS MaxDate
FROM Staff LEFT JOIN TSHistory ON Staff.StaffID = TSHistory.StaffID
WHERE (((Staff.Active)=True))
ORDER BY [FName] & " " & [LName];

If I change it to the following, I get an error message of Invalid Dot
Operator:

SELECT Staff.StaffID, [FName] & " " & [LName] AS FirstLast,
DMax("[PeriodBeginning]","TSHistory"," [StaffID] = " & [Staff].[StaffID]) AS
MaxDate
FROM Staff LEFT JOIN TSHistory ON Staff.StaffID = TSHistory.StaffID
WHERE (((Staff.Active)=True))
ORDER BY [FName] & " " & [LName];

Can anyone help me solve it?

Thank you.
Sprinks

 

[Klatuu]

Change them to use !
[Staff]![StaffID]

 

[Sprinks]

Thank you, Klatuu. This one is a little embarassing, since I occasionally
get on my soapbox distinguishing the uses of the dot and bang operators!

Best regards.
Sprinks

Change them to use !
[Staff]![StaffID]

Access reports that the following is ambiguous because [StaffID] is a field
in both tables:

SELECT Staff.StaffID, [FName] & " " & [LName] AS FirstLast,
DMax("[PeriodBeginning]","TSHistory"," [StaffID]= " & [StaffID]) AS MaxDate
FROM Staff LEFT JOIN TSHistory ON Staff.StaffID = TSHistory.StaffID
WHERE (((Staff.Active)=True))
ORDER BY [FName] & " " & [LName];

If I change it to the following, I get an error message of Invalid Dot
Operator:

SELECT Staff.StaffID, [FName] & " " & [LName] AS FirstLast,
DMax("[PeriodBeginning]","TSHistory"," [StaffID] = " & [Staff].[StaffID]) AS
MaxDate
FROM Staff LEFT JOIN TSHistory ON Staff.StaffID = TSHistory.StaffID
WHERE (((Staff.Active)=True))
ORDER BY [FName] & " " & [LName];

Can anyone help me solve it?

Thank you.
Sprinks

 

[Klatuu]

LOL,
yep, I've seen you post about that

Funny about how the ! is used in different environments. We usually refer
to it as bang. Long ago when I worked on Tandem computers, it was called the
dammit.
That was because you could issue a command with the ! on the end of it and
it meant execute the command without asking me it I really want to do it. We
thought of it as DO IT DAMMIT

Thank you, Klatuu. This one is a little embarassing, since I occasionally
get on my soapbox distinguishing the uses of the dot and bang operators!

Best regards.
Sprinks

Change them to use !
[Staff]![StaffID]

Access reports that the following is ambiguous because [StaffID] is a field
in both tables:

SELECT Staff.StaffID, [FName] & " " & [LName] AS FirstLast,
DMax("[PeriodBeginning]","TSHistory"," [StaffID]= " & [StaffID]) AS MaxDate
FROM Staff LEFT JOIN TSHistory ON Staff.StaffID = TSHistory.StaffID
WHERE (((Staff.Active)=True))
ORDER BY [FName] & " " & [LName];

If I change it to the following, I get an error message of Invalid Dot
Operator:

SELECT Staff.StaffID, [FName] & " " & [LName] AS FirstLast,
DMax("[PeriodBeginning]","TSHistory"," [StaffID] = " & [Staff].[StaffID]) AS
MaxDate
FROM Staff LEFT JOIN TSHistory ON Staff.StaffID = TSHistory.StaffID
WHERE (((Staff.Active)=True))
ORDER BY [FName] & " " & [LName];

Can anyone help me solve it?

Thank you.
Sprinks