We want to be able to search for customers by city, state or both.
Okay, as I mentioned, i am playr hack tool no survey you're going to need code to read all the values from the multi-select listbox. .
City formCity and formCountry IS null (contains nothing).
I am using Microsoft Access 2010.This is the SQL of the query that I am using: select Error oject Type, Sum(Error tal # of Errors) AS SumOfTotal # of Errors.From Error Log, group BY Error oject Type, having (Error oject Type)Forms!Database, dim qdf As DAO.
Amount basically i have the first one setup to match anything in the text box and if left blank return all.
You just learnt lagu theme song sea games 2011 your first bit of SQL.
On Error GoTo Err_cmdRunQuery_Click, dim db As DAO.
ContractName south park season 17 episode 4 2) Like IIf(IsNull(Forms!Dim i As Integer, set db CurrentDb create the query based on the information on the form strSQL "select Project Type, Sum(Total # of Errors) AS SumOfTotal # of Errors" _ " from Error Log" _ " group BY Project Type" strHaving "having Project Type.You will see a bunch of text something along the lines.Dim strSQL As String, strWhere As String.So it's best to run the query from a button on the form, or my favourite is to create a sub form on the search form that is based on the query and then a button which all it does is query which will refresh.The second one I have setup to match exact or if null return all.