How to Delete particular records from multiple tables in one shot

Dear all experts,

Firstly, thank you very much for your helping. i am beginner for doing access.

There are three things i would like to do, but really cannot do it, please all experts for help.


The first things is How to Delete particular records from multiple tables in one shot

There are table of "no" to link all "tbl18", "tbl19", "tbl20", queries of "d1" and "d2" is for result to compare the data.

"代號" is used to link all data together, i want to do the function of delete, the box come out, for example i type 827,

then all data of 827 in table of "no", "tbl18", "tbl19", "tbl20" will delete. This is the first i would like to do.


The Second, when you "d1", 18m is the max value on that day of 18, 18p is the main value on that day of 18,
i would like to do if the 19p higher than 18m, then 19p reamin the value, if 19p < 18m, the value clear or disappear or unshow
unitil other date get value and compre 18m, i know hard to understand

for example 279, 19p <18m, where 18m is 0.088 and 19p is 0.75, then 19p value should disappear in queries of "d2"
for example 2312, 23p< 20m, then 23p value should disappear in queries of "d2"


Third count number of value at one particular column in queries of "d2"
for example 433, total appear is 3 ,
for example 1175, total appear is 2,


Again, thx for help, i know it should be hard to do. Thank you.