CodyMonster
Board Regular
- Joined
- Sep 28, 2009
- Messages
- 159
Wondering if this is possible..
I want to make one delete query that will remove data from multiple tables. However, I also want to use a date criteria from a form. For example, only a specific date of data removed from 6 tables, but the date comes from the end user in a form.
There are 6 tables for group, and there are 5 groups to delete information from. Is it possible to do on group in one delete query?
Or must I only use one delete query for each table.
Which, I guess I can do, it just creates a large number (30 to be exact) of delete queries.
Thanks
I want to make one delete query that will remove data from multiple tables. However, I also want to use a date criteria from a form. For example, only a specific date of data removed from 6 tables, but the date comes from the end user in a form.
There are 6 tables for group, and there are 5 groups to delete information from. Is it possible to do on group in one delete query?
Or must I only use one delete query for each table.
Which, I guess I can do, it just creates a large number (30 to be exact) of delete queries.
Thanks