Error Message -- SELECT statement includes...

[Princessboko]

I have a database that I'm trying to build a form for. I go into the Query Builder and select all the fields I want to be on the form. Before I leave the Query Builder I run the query and see all the fields. When I leave the Query Builder and try to look at the form I get this error:

"The SELECT statement includes a reserved word or an argument name that is misspellec or missing, or the punctuation is incorrect"

Here's my statement:

SELECT Employees.EmployeeId, Employees.CaseNumber, Employees.FName, Employees.LName, Employees.StAddress, Employees.City, Employees.State, Employees.Zipcode, Employees.Phone, Employees.Dept, Employees.JobCat, Employees.Description, Source.SourceID, Source.EmployeeID, Source.SourceName, Source.SourceUknwn, Source.AttendingDr, Source.KnownHiv, Source.HistoryIV, Source.ManWMan, Source.CommWkr, Source.NonAbove, Source.SourceHepB, Source.SourceHepC, Source.SourceHIV, Source.DateHepb, Source.DateHepC, Source.DateHiv, Source.SourceResultsHepB, Source.SourceResultsHepC, Source.SourceResultsHiv, Source.EHRN, BaselineTest.BaselineID, BaselineTest.SourceID, BaselineTest.EmployNot, BaselineTest.SourceDocNot, BaselineTest.HBVExposure, BaselineTest.BaseABLevel, BaselineTest.ABTesDate, BaselineTest.TestDone, BaselineTest.BaseHepb, BaselineTest.HepbDrDate, BaselineTest.BaseHepc, BaselineTest.HepCDrDate, BaselineTest.BaseHIV, BaselineTest.ConsentSign, BaselineTest.HIVDrDate, BaselineTest.ClotStudy, BaselineTest.ClotDrDate, BaselineTest.ResultsID, BaselineTest.SumDate, BaselineTest.Pep, BaselineTest.HepbVac, BaselineTest.Comment, BaselineTest.SixWk, Results.ResultsID, Results.BaselineId, Results.HIVSixWDue, Results.HIVSixWDone, Results.HIVResult, Results.HIVTwelvWDue, Results.HIVTwelvWDone, Results.HIVTwelvWResult, Results.HIVSixMDue, Results.HIVSixMDone, Results.HIVSixMResult, Results.HBABDue, Results.HBABDone, Results.HBABResult, Results.HBABTwoDue, Results.HBABTwoDone, Results.HBABTwoResult, Results.LiverDue, Results.LiverDone, Results.LiverResult, Results.ResultComment
FROM ((Employees INNER JOIN Source ON Employees.EmployeeId = Source.EmployeeID) INNER JOIN BaselineTest ON Source.SourceID = BaselineTest.SourceID) INNER JOIN Results ON BaselineTest.BaselineID = Results.BaselineId;

I've looked at this so much I can't see the error. Any suggestions would be most appreciated.

Thanks!

 

[Joe4]

Your SELECT statement contains an awful lot of fields. I would try re-creating the query, adding a few fields at a time to see if you can pinpoint exactly what command is causing the error.

 

[drjekyll325]

The query must be fine if you are able to execute it. It sounds to me like there is some problem with the form. Have you checked the data source and any filters of the form?

 

[mdmilner]

I didn't see anything obvious in the query, although it is long. Use the Form Builder Wizard and recreate it from scratch to see if it can place all the fields.

You might try this though - you can simplify queries manually following the format "SELECT * FROM tblName" by editing the SQL version directly. This does make one broad assumption. You are including ALL fields from the indicated tables into your query.

In your case it would be:

SELECT Employees.*, Source.*, BaselineTest.*, Results.* FROM ((Employees INNER JOIN Source ON Employees.EmployeeId = Source.EmployeeID) INNER JOIN BaselineTest ON Source.SourceID = BaselineTest.SourceID) INNER JOIN Results ON BaselineTest.BaselineID = Results.BaselineId;

Mike

 

[Princessboko]

Thanks all. Last night I recreated the whole thing and it seems to be working fine this morning.

Thanks all for your help.