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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append query wont run because: 8
Is this Possible - Dynamic Field Selection within a QBE grid? 1
Return a blank feild 2
Unlinked Tables affecting Query? 5
Count repeats 1
Counting the sum of related records for a primary record 4
View unavailable 5
2 fields of different lenghts 2

Back
Top