ElmoFringby30
Programmer
How do I create a query that will delete items from table number 1 when it matches items in table number 2?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Delete Query
- Thread starter ElmoFringby30
- Start date
- Status
You might be better off asking this in one of the Access forums but basically, just set up a new query in design mode
Bring in the table you want to delete items off
Select all fields
In the criteria for the field you want to match on, right click and choose BUILD
In the build wizard, double click on TABLEs and then on teh table you want to match to then double click on the field you want to match to
It should now appear in teh formual editor
OK this and your criteria section on the field you want to match on will now have =[TableName][FieldName]
Run the query (But make a backup of the original tabkle 1st....just in case) Rgds
~Geoff~
Bring in the table you want to delete items off
Select all fields
In the criteria for the field you want to match on, right click and choose BUILD
In the build wizard, double click on TABLEs and then on teh table you want to match to then double click on the field you want to match to
It should now appear in teh formual editor
OK this and your criteria section on the field you want to match on will now have =[TableName][FieldName]
Run the query (But make a backup of the original tabkle 1st....just in case) Rgds
~Geoff~
- Status
Similar threads
- Locked
- Question