I wonder if somebody could help me solve a problem I have. When the qry below is fired i basically want it to display data 2 weeks before the current date. So I need some form of calculation similar to the following:
sSql1 = "select * from qryclosed where [date closed] = todays date - 14 days
so if i launched the qry today it should pull all data with a closed date from 2/11/04 through to 15/11/04.