gibbo1715
11-05-2005, 03:34 AM
I have a userform in excel which links to an access database and runs an sql query giving the results in a userform
I use the code below for the query
strSql = "SELECT * From Applications WHERE Applicant= '" & txtSearch & "';"
What I need to be able to do is run an SQL query that checks if column due_Date is before today and Column Submitted_Date is not a null value (i.e. blank)
I know this is not strictly an excel question but my interface is excel based and you ve helped me with similar in the past
cheers
Gibbo
I use the code below for the query
strSql = "SELECT * From Applications WHERE Applicant= '" & txtSearch & "';"
What I need to be able to do is run an SQL query that checks if column due_Date is before today and Column Submitted_Date is not a null value (i.e. blank)
I know this is not strictly an excel question but my interface is excel based and you ve helped me with similar in the past
cheers
Gibbo