Query Output

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,

I would need your help and how to use combine #1, #2, #3 for Query Output.
I am able to produce a query for each #1, #2 and #3 without a problem.

I try to figure it out when I want all three (#1,#2,#3) together to give an
output query. Your help would be much appreciated. Hear from you soon!

strFieldName = Car
strFieldName2 = Airplane
strFieldName3 = Boat

#1
strSQL = "SELECT Table_A.* FROM Table_A " & _

"WHERE Table_A.[FieldName] " & strFieldName



#2
strSQL = "SELECT Table_A.* FROM Table_A " & _

"WHERE Table_A.[FieldName] " & strFieldName2



#3
strSQL = "SELECT Table_A.* FROM Table_A " & _

"WHERE Table_A.[FieldName] " & strFieldName3
 
Bill,

The code and SQL statements you posted below won't work.

It sounds as if you want to return all records where [FieldName] is
"Car" or "Airplane" or "Boat". You need to something like this:

strSQL = "SELECT * From Table_A " _
& " WHERE [FieldName] IN ('" & strFieldname & "', '" _
& strFieldName2 & "', " & strFieldname3 & "');"

to get

SELECT * FROM Table_A WHERE [FieldName] IN ('Car', 'Airplane', 'Boat');

Hi,

I would need your help and how to use combine #1, #2, #3 for Query Output.
I am able to produce a query for each #1, #2 and #3 without a problem.

I try to figure it out when I want all three (#1,#2,#3) together to give an
output query. Your help would be much appreciated. Hear from you soon!

strFieldName = Car
strFieldName2 = Airplane
strFieldName3 = Boat

#1
strSQL = "SELECT Table_A.* FROM Table_A " & _

"WHERE Table_A.[FieldName] " & strFieldName



#2
strSQL = "SELECT Table_A.* FROM Table_A " & _

"WHERE Table_A.[FieldName] " & strFieldName2



#3
strSQL = "SELECT Table_A.* FROM Table_A " & _

"WHERE Table_A.[FieldName] " & strFieldName3
Click to expand...
 
I assume that your strSQL strings do actually work, and you've simply
mistyped them here; also that your variables to hold your strings are
actually populated with statements such as
strFieldName = "Car"

If what you need is a query-string that will return records where
[FieldName] is any of Car, Airplane or Boat, try this:
strSQL = "SELECT Table_A.* FROM Table_A " & _
"WHERE Table_A.[FieldName] = ('" & strFieldName & _
"' OR '" & strFieldName2 & "' OR '" & strFieldName3 & "');"

You can simplify it if you want (since everything is in the same table):
strSQL = "SELECT * FROM Table_A " & _
"WHERE [FieldName] = ('" & strFieldName & _
"' OR '" & strFieldName2 & "' OR '" & strFieldName3 & "');"


HTH,

Rob
 
Forgive the brain-fade yesterday! The "[FieldName] = " bit needs to be in
each OR section, so this should be:

strSQL = "SELECT * FROM Table_A " & _
"WHERE [FieldName] = '" & strFieldName & _
"' OR [FieldName] = '" & strFieldName2 & "' OR [FieldName] = '" &
strFieldName3 & "');"

Alternatively, use the IN syntax suggested by another poster.

Rob

"Rob Parker" <CUT_THIS robpparker at optusnet dot com dot au> wrote in
message
strSQL = "SELECT * FROM Table_A " & _
"WHERE [FieldName] = ('" & strFieldName & _
"' OR '" & strFieldName2 & "' OR '" & strFieldName3 & "');"
Click to expand...
<snip>
 
Back
Top