SQL WHERE clause (How do I indicate entire table)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SQL WHERE clause usually asks you to enter each field you want to search. I
would like to know if there's a quick short hand for indicating I want a
search on the entire table without entering every field!

SELECT
FROM
WHERE
 
SQL WHERE clause usually asks you to enter each field you want to search. I
would like to know if there's a quick short hand for indicating I want a
search on the entire table without entering every field!

SELECT
FROM
WHERE
Click to expand...

You have to be specific.
Where TableName.FieldA = "X" or TableName.FieldB = "X" or etc.
 
fredg said:
You have to be specific.
Where TableName.FieldA = "X" or TableName.FieldB = "X" or etc.
Click to expand...
Thank you for responding. I understood that I had to use the naming
convention you mentioned. I'm interested in knowing whether it's possible to
avoid having to enter in the .Field? Is there a naming convention that
indicates a search over the entire table?
 
He said "You have to be specific."
You can search a whole table using the binocular icon and selecting the
table in the 'Look In:'
 
NO there is not. You MUST list the fields.

You can do concatenate the fields together and check them all at once,
but that is not efficient and is almost as much trouble.

WHERE Field1 & "/" & Field2 & "/" & Field3 & "/" & field4 Like
"*SAMIAm*"

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top