SQL WHERE clause (How do I indicate entire table)

[beginnersmind]

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

 

[fredg]

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

You have to be specific.
Where TableName.FieldA = "X" or TableName.FieldB = "X" or etc.

 

[beginnersmind]

You have to be specific.
Where TableName.FieldA = "X" or TableName.FieldB = "X" or etc.

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?

 

[KARL DEWEY]

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:'

 

[John Spencer]

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
'====================================================

 

[beginnersmind]

You have to be specific.
Where TableName.FieldA = "X" or TableName.FieldB = "X" or etc.

Thank you for the help. It worked! Have a great weekend!