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 from the field 'closed date' starting from 2/11/04 through to 15/11/04.
I hope this makes sense.
Thanks in advance