Error Message: " is not valid name. Make sure that it does not include invalid char

[sgtSortor]

Error Message: " is not valid name. Make sure that it does not include invalid char

HELP! I've recently been upgraded to Access 2007 and am having this new issue.

Everytime I create a query and add a second table to the query, I get this error message:

" is not valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

Following is the SQL Code for one of my reports:


SELECT tblPanelMembers.PnlBrdMbrID, tblPanelMembers.PanelID, tblPanelMembers.LbrMgmt, tblPanelMembers.PersonsID, tblPanelMembers.Title, tblPanelMembers.DateEntered, tblPanelMembers.EnteredBy, tblPanelMembers.Title
FROM tblPanelMembers INNER JOIN tblPanel ON tblPanelMembers.PanelID = tblPanel.PanelID
WHERE (((tblPanelMembers.Title) Is Null Or (tblPanelMembers.Title)<47));


I can look at the query in SQL view, but not in query design view.

The report will sometimes open, but other times not.......

It's beginning to get very irritating. PLEASE HELP

 

[RuralGuy]

Re: Error Message: " is not valid name. Make sure that it does not include invalid

Have you applied the latest Office 2007 Service Pack?

 

[DCrake]

Re: Error Message: " is not valid name. Make sure that it does not include invalid

A quick look at your SQL I think the word Title (field name) is a reserved word. Try changing it if possible and retry. To quickly test if this is the case remove the field from the query and try to run it. If it works ok add it back retry. If it fails then this is the problem.

David

 

[Kiwiman]

Re: Error Message: " is not valid name. Make sure that it does not include invalid

Howzit

Could it be because the tblPanelMembers.Title is selected twice in the SELECT part, without one of them being given an Alias?

SELECT tblPanelMembers.PnlBrdMbrID, tblPanelMembers.PanelID, tblPanelMembers.LbrMgmt, tblPanelMembers.PersonsID, [B]tblPanelMembers.Title[/B], tblPanelMembers.DateEntered, tblPanelMembers.EnteredBy, [B]tblPanelMembers.Title[/B]
FROM tblPanelMembers INNER JOIN tblPanel ON tblPanelMembers.PanelID = tblPanel.PanelID
WHERE (((tblPanelMembers.Title) Is Null Or (tblPanelMembers.Title)<47));

 

[Balr14]

Re: Error Message: " is not valid name. Make sure that it does not include invalid

I get the same error just by selecting the table name; I don't even get as far as selecting a field.