Some More Help Needed <_<

[fortlansing]

Problem:

"Display the Client Number, Name, and Balance fields for all the clients where the bookkeeper number is 22 or 24 and the balance is greater than $300.00."

how can I do all the operations @ the same time in one query???

I'me new to Access to I really need to know.

Thanks

 

[Peter Reid]

Problem:

"Display the Client Number, Name, and Balance fields for all the clients where the bookkeeper number is 22 or 24 and the balance is greater than $300.00."

how can I do all the operations @ the same time in one query???

I'me new to Access to I really need to know.

Thanks

SELECT [Client Number], [Name], Balance
FROM tbl_Clients
WHERE ([Bookkeeper number] = 22 OR [Bookkeeper number] = 24) AND Balance >300