Delete Query Does Not

Should I start a new thread? We seem to have used up all the space in this
one.

Take care,

Dear Ron:

You can make the column wider, and we can keep going for another month or
so.

I think you should try again, and I'll let someone else see what they can
do, if you'd like.

I might also be able to do a better job looking at your database. If you
wish, you can send it to me.

1. Compact and Repair

2. Make a copy of the file

3. Rename the copy, making the file extension XXX instead of MDB

4. Compress with Zip

5. Check size of zip file. Under 2 MB?

6. Attach to email and send to me. I post with my real email address, and
live with the spam.

I will be very busy all week, but may look at this Tuesday or so.

Tom Ellison


"Ron Le Blanc" wrote in message
...
Should I start a new thread? We seem to have used up all the space in this
one.

Take care,

I have sent a copy of the database to Tom Ellison. Would you like a copy
also John Vinson?? It's fairly small, about 650Kb.

Take care

"John Vinson" wrote in message
...
On Sun, 12 Feb 2006 20:31:18 -0500, "Ron Le Blanc"
wrote:

Sorry guys, the SQL given below does not work. If I make it a Select Query
it returns a single empty record.

Let me reiterate, because I think this WILL work and it's what Tom is
trying to explain in other language:

DELETE * FROM Client
WHERE MasterID NOT IN
(SELECT DISTINCT MasterID FROM Meals
WHERE Meals.LastVisit DateAdd("yyyy", -2, Date()))
AND MasterID IN
(SELECT DISTINCT MasterID FROM Meals
WHERE Meals.LastVisit = DateAdd("yyyy", -2, Date()));

The two subselects will pick those people who DID NOT have any meal in
the past two years (the first subselect), but it will also require
that the person DID have a meal prior to that time (the second
subselect).

John W. Vinson[MVP]

Dear John, (ooops! That doesn"t sound right. )

Copy of files sent to Tom Ellison.