How to select records of the same Type

  • Thread starter Thread starter girish
  • Start date Start date
G

girish

Hi,
I have the requirement to select records of the same
Type.The record once selected must not selected again.One
idea i got is to have a column and update the column after
the select.But Update will update all the rows for that
type

Any help in this regard is highly appreciated

subbu
 
But Update will update all the rows for that
type

An Update query can have criteria. Depending on the criteria, it might
update all records in the table, half of them, just one record, or no
records at all.

Can you apply a criterion based on the record that was selected? How
are you "selecting" the single record?
 
Back
Top