Select statement

[cschaffer]

strQuery = "SELECT DisasterName, DisasterType, Detail, Date, Country FROM Disasters WHERE DisasterType = '" & isit1 & "'" '&' "Date = #" & isit2 & "#" '&' "Country = '" & isit3 & "'"

*********************************************
That is my code....it works ...kind of......Now what I am trying to get here is to display the results only if ALL the conditions are met...what it is doing now is displaying the results of 'DisasterType'........and doesn't care about the rest of the conditions.......thanks for the help....

CS

 

[Maquis]

I think you need to add some spaces and some "ands" into your query. Translating the variables you've pasted above into a SQL statement, here's what you get:

SELECT DisasterName, DisasterType, Detail, Date, Country FROM Disasters WHERE DisasterType = 'isit1name'&Date = #isit2date#&Country = 'isit3field'


Should read like this:


SELECT DisasterName, DisasterType, Detail, Date, Country FROM Disasters WHERE DisasterType = 'isit1name' AND Date = #isit2date# AND Country = 'isit3field'

Maq B-)
<insert witty signature here>

 

[cschaffer]

Thanks ...altough that gives me the same results.....



CS

 

[Maquis]

Hmmm, I would suggest inserting a msgbox into your VBA code to display exactly what your SQL string looks like. Perhaps when you see the actual sql statement, you'll be able to see what's wrong with it.

If you can't see it, then post the statement here. Perhaps someone else can see something we've missed. Maq B-)
<insert witty signature here>

 

[THoey]

Please post some sample data and the results you would like to see... Terry M. Hoey