I need help of writing the following if then
1. If in qry [gd_rp] below: If scope for a (Unit Number) = "90" and (Kitchen Floor) = "Replace"
2. Go to Qry [Floor] read and find the (xmcode) data ex.+APPR4/3P40A
3. in qry [combo] below: find the same (xmcode) data in the [combo] qry below and subtract the (qty) number from the [floor] Qry from the (qty) number in [combo] qry and create a new column in [combo] and place that value in the new column
End
Then separately i need same logic to change
1. If in qry [gd_rp] below: If scope for a (Unit Number) = "FS" and (Kitchen Floor) = "Good"
2. Go to Qry [Floor] read and find the (xmcode) data ex.+APPR4/3P40A
3. in qry [combo] below: find the same (xmcode) data in the [combo] qry below and ADD the entire row from Qry [Floor] to qry [combo] data by unit
End