Simple query help

  • Thread starter Thread starter ross
  • Start date Start date
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
 
Set the criteria under tableOne.DateField to
Between tableTwo.DateField and DateAdd("d",14,tableTwo.DateField)
 
Back
Top