Hello
I am hoping someone can help identify where I am going wrong ... I am having some trouble with the where clause - i think it is the ContractRenewal that is wrong - I need to show all companies whose contract is up for renewal in 3 months time...
lsSQL = ""
lsSQL = lsSQL & " SELECT [Company],[ContractRenewal] FROM tbl_Company "
lsSQL = lsSQL & " Where ContractRenewal = <Now()+90 "
lsSQL = lsSQL & " & CompanyType = 1"
lsSQL = lsSQL & " & Archived = False"
Thanks in anticipation....
I am hoping someone can help identify where I am going wrong ... I am having some trouble with the where clause - i think it is the ContractRenewal that is wrong - I need to show all companies whose contract is up for renewal in 3 months time...
lsSQL = ""
lsSQL = lsSQL & " SELECT [Company],[ContractRenewal] FROM tbl_Company "
lsSQL = lsSQL & " Where ContractRenewal = <Now()+90 "
lsSQL = lsSQL & " & CompanyType = 1"
lsSQL = lsSQL & " & Archived = False"
Thanks in anticipation....