Whta is wrong with this query

[Lou_Reed]

Well, I guess if you cannot beat them, then you join them!
The db that is in the file that I have attached works now on the frmPersonnel. There are no more green triangles in the upper corner. The method that I used was to simply export
the query that works into the db that had the query that did not work.

Then I did some renaming and everything is alright - it works now. The query that works is qryPersonnel and the query that does not work is qryPersonnel2, and they are both in the attached db.

I am not sure why one works and the other does not. I just tried to open the frmPersonnel and it opened flawlessly with no problems by using the new query (which of course was renamed to the old query name) and the old nonworking query is now call qryPersonnel2. When I open frmPersonnel in design mode, the controls no longer had a green triangles in the upper left corner.



I just have one question, and that is what is wrong with qryPersonnel2? Why does it fail to work? If one wants to try it is named now qryPersonnel2 or one on the previous posts in this thread had

an attachment that was the whole malfunctioning db with the faulty query. One could also simply substitute qryPersonnel2 for qryPersonnel (remember that is the one that works).

Then open fmPersonnel and you will see what I mean.

I really hope this does not sound too complicated, but I tried to explain it simply.

Any help appreciated. Thanks in advance.


Respectfully,


Lou Reed

[RayMilhon]

Ok, Opened your Database both queries worked fine. Returned the same data set. although in the one I opened there was no qryPersonnel2 there was a qryPersonnel and a qryPersonnel1

[Lou_Reed]

I am sorry, it is qryPersonnel1 not QryPersonnel2!

If you use qryPersonnel1 in place of qryPersonnel, (do not forget to rename them since the frmPersonnel is setup only one way) you will see my point.

What I mean by the parenthetical expression is the form, frmPersonnel is only setup for qryPersonnel. So whichever query you use must be named qryPersonnel.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[jwhite]

cboSelectPersonnel
Change Rowsource to:

SELECT tblPersonnel.PersonnelID, [LastName] & ", " & [FirstName] AS FullName FROM tblPersonnel WHERE (((tblPersonnel.isDeleted)=False)) ORDER BY tblPersonnel.LastName, tblPersonnel.FirstName;

Change the Bound Column property from 2 to 1
Change Column Count from 1 to 2