Query Question

[Andrew]

I have produce a basic query from two table which sorts by an ascending
date

How do I make the query cut off those dates which are say six months in
advance of today

Regards

Andrew

 

[Dodo]

I have produce a basic query from two table which sorts by an ascending
date

How do I make the query cut off those dates which are say six months in
advance of today

Regards

Andrew

Set criteria in query at DateField:

DateSerial(year;month;day)

You probably use the separator ","