Including records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that pulls back all records that have a >0 value. It works
fine. The problem is that I have a few records that contain a 0 value that I
would like to include in my results. These results include part number,
price and descritions fields. Maybe I can use the part number to include
those records? How can I achieve both?

Thanks.
 
rml said:
I have a query that pulls back all records that have a >0 value. It works
fine. The problem is that I have a few records that contain a 0 value that I
would like to include in my results. These results include part number,
price and descritions fields. Maybe I can use the part number to include
those records? How can I achieve both?
Click to expand...

The WHERE clause of the query:

WHERE column_name > 0
OR (column_name = 0 AND part_nbr = 1234)
 

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

Similar Threads

selecting the right 'MAX' record 3
Access Dcount (multiple criteria) 3
Simple question about query result 2
Make table query: [Enter 1] AS Test 1
Include records even if date is null 4
Select query returning too many records 2
Creating a total query 4
Parameter Query Problem 2

Back
Top