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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by TheOnlyKickBack
-
How do I search every field in a table with a query
pbrodsky, i'm not actually putting the results in a form. traingamer, thanks for the help, it now works great! by only telling the query to search the text fields, it now does what I want it to do. thanks again, and to everyone else. Nathan- TheOnlyKickBack
- Post #10
- Forum: Microsoft: Access Queries and JET SQL
-
How do I search every field in a table with a query
As requested, here is my SQL code: SELECT tblCustomer.Cust_ID, tblCustomer.Cust_First, tblCustomer.Cust_Last, tblCustomer.Cust_AddLn1, tblCustomer.Cust_Town, tblCustomer.Cust_Postcode, tblCustomer.Cust_TelNo, tblCustomer.Cust_Email, tblCustomer.Delivery_Discount FROM tblCustomer WHERE...- TheOnlyKickBack
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
How do I search every field in a table with a query
If you mean the fields are set in stone, yes they are. If you mean the records are set in stone, no they're not. Could you please be more specific, as I have constructed this query in design view and lack knowledge of SQL. Thank you in advance.- TheOnlyKickBack
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How do I search every field in a table with a query
I want a query to search a table for criteria, and return all records that contain the criteria in ANY field. The criteria is entered using a form, with the following expression, but copying it to every field in the query comes up with #NAME?: [Forms]![frmCustQuery]![txtQueryInput] I was...- TheOnlyKickBack
- Thread
- Replies: 9
- Forum: Microsoft: Access Queries and JET SQL
