Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing select statement to query to report problems
Thanks! that worked great. -JB- jberna2
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Passing select statement to query to report problems
I removed the strWhere from the open report statement. It is now working as intended. I figured if I filtered the query I didn't really need to put the same filter again in the report, and somehow it fixed itself. My only problem now is that if I try to print out only one Employee_Number or...- jberna2
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Passing select statement to query to report problems
I am having trouble with my syntax somewhere. I have 3 tables: Employee -------- Employee_Number (pk) Employee_FirstName Employee_MiddleI Employee_LastName Area Infraction --------- Infraction_Code (pk) Infraction_Description Inventory ---------- Employee_Number (foreign from Emp table)...- jberna2
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
