please help

[trre]

i am trying to produce a query with the fields customer number, customer name, invoice amount, and paid for customers 107 and 122. what should the criteria be?

 

[KARL DEWEY]

If your [customer number] field is text then this --
SELECT [customer number], [customer name], [invoice amount], [paid]
FROM YourTable
WHERE [customer number] = "107" OR [customer number] = "122";

If your [customer number] field is a number datatype then this --
SELECT [customer number], [customer name], [invoice amount], [paid]
FROM YourTable
WHERE [customer number] = 107 OR [customer number] = 122;