Append Query

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

Guest

Hi

I have table where that I want to remove about 5,00 records. All this
records contain an investor_code

The records I want to remove are records with investor_code = P

I know I can use an Append Query but I never done an append query before.
Can anyone help me with the criteria.
 
Jose Aleman said:
Hi

I have table where that I want to remove about 5,00 records. All this
records contain an investor_code

The records I want to remove are records with investor_code = P

I know I can use an Append Query but I never done an append query before.
Can anyone help me with the criteria.
Click to expand...

You don't want an Append Query, you want a Delete Query.
Just add the investor_code field to the query grid.
In the criteria field put

="P"

Tom Lake
 
Back
Top