Simple query help

R

ross

Hi,
I have 2 table. These are linked by a phone number in a one to many.

Each table has a data feild.

I would like a query to return only data where the date feild in
table one is the same or up to 14 days after that in table two.

I'm using the QBE grid, how can i do this!!!!

Many thanks
 
D

Duane Hookom

Set the criteria under tableOne.DateField to
Between tableTwo.DateField and DateAdd("d",14,tableTwo.DateField)
 
Top