Converting Value List to separate tables or queries 1

[neilgeurin2000]

Hi, this is probably exceptionally simple but it is beating me down so I thought I would ask:

I have a query which lists a member code in one column and a one digit number (anything from 0 to 7) in the second column which corresponds to number of transactions. I would like to separate the people with a 2 value from everyone else, is there an easy way to convert these people to a new table or query? Thanks in advance.

 

[Golom]

How 'bout
[blue][tt]
Select MemberCode
From myQuery
Where NumberOfTransactions = 2
[/tt][/blue]

 

[neilgeurin2000]

Thanks for putting up with silly questions. Your answer worked perfectly and I appreciate it!