If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
Delete Query Does Not
Should I start a new thread? We seem to have used up all the space in this
one. Take care, |
#32
|
|||
|
|||
Delete Query Does Not
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, |
#33
|
|||
|
|||
Delete Query Does Not- To John Vinson
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] |
#34
|
|||
|
|||
Delete Query Does Not
Dear John, (ooops! That doesn"t sound right. )
Copy of files sent to Tom Ellison. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete Query Doesnt | Ron Le Blanc | Running & Setting Up Queries | 7 | February 8th, 2006 01:21 AM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |