how do i delete records based on a "if x=1 and Y<less than" condi.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i delete records based on, for example: "if there is a specific value
in column 1 of table 1 and column 2 in table 1 is less than a value in a
column of table 2?
 
How do i delete records based on, for example: "if there is a specific value
in column 1 of table 1 and column 2 in table 1 is less than a value in a
column of table 2?
Click to expand...

I have no idea, since I have no way of knowing anything about your
table structure or how the tables are related. I'd presume you would
create a Query joining the two tables on some appropriate linking
field, and apply criteria to the two fields.

A more specific example of what you want would certainly be helpful.

John W. Vinson[MVP]
 
Back
Top