Dates

A

a

thank you
please notes that I send this also to query forum!!!
table 1
ID BeginDate EndDate
1 1/1/2004 5/1/2004
2 10/1/2004 20/1/2004
3 10/2/2004 20/2/2004
table 2
contain dates take from dates in table1 ((subtracted) (cuts)
ID BeginDate EndDate
1 1/1/2004 3/1/2004
2 10/1/2004 12/1/2004
2 16/1/2004 18/1/2004
3 17/2/2004 20/2/2004
the question is how can I retuern query like the following
Here Is the query for what I want please (see it)
ID BeginDate EndDate
1 4/1/2004 5/1/2004
2 13/1/2004 15/1/2004
2 19/1/2004 20/1/2004
3 10/2/2004 16/2/2004
pleas see that the query return dates not taked in table 2
thank you and hope you can help
 

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

Top