Simple SQL statement

[Ste4en]

Can anyone help me do this and than tell me how to see the results of the statement so i can see how the result changes when i make changes

I want:

zone = "08" and circuit <> "Deleted" i am using

"zone='" & me.cmbzone & "'" & "AND circuit <>'" & " ' "Deleted" ' "

Thanks

 

[RuralGuy]

Try:
Dim strWhere As String
strWhere = "zone = '" & me.cmbzone & "' AND circuit <> 'Deleted'"
MsgBox strWhere

 

[Ste4en]

that did the trick, thanks

 

[RuralGuy]

Glad to assist and thanks for posting back with your success.