My query is not returning any data even when I only put in one table. The table has data. What could be causing this?
Competent Performer
Windows XP 
Access 2003
My query is not returning any data even when I only put in one table. The table has data. What could be causing this?
Access/SQL Server Expert
Windows XP Access 2003
Possibly criteria in the query. Could you maybe supply more details?
Competent Performer
Windows XP Access 2003
I've attached the Q. I took out all of the criteria and still get no data.
What I would like to do is add the below criteria which I think would go under PKPeopleID.
[Forms]![LookupFm_Bldgs_Under_A_Person]![PersonCombo]
LookupFm_Bldgs_Under_A_Person bound column is 1; (I want the last name to stay in the box once selected.)
Row Source: SELECT LookupTbl_People.PKLookupPeopleID, LookupTbl_People.LastName, LookupTbl_People.FirstName FROM LookupTbl_People ORDER BY [LastName], [FirstName];
If this doesn't give you enough information let me know.
Competent Performer
Windows XP Access 2003
Sorry here is the attachment
Query doesn't return all data
Posting Permissions
Reply With Quote