How to select records of the same Type

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
 
J

John Vinson

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?
 

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

Top