please help

  • Thread starter Thread starter trre
  • Start date Start date
T

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?
 
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;
 
Back
Top