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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Checking if data exists another table and, if yes, extracting a value 0
How to Populate Data from a table to another 0
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Query to copy selective records (and modify a column) 3
excluding records based on a table 3
Less than 1 Year 3
Values from multipule records in 1 record 4

Back
Top