Query Question

A

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
 
D

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 ","
 
Top