Query not returning all results

[washingtons]

I have a table listing a number of cell phone products and their carrier along with their status' in the production process. I want the query to return the most recent status for each product for each carrier. However, out of the 20+ products that I'd like the most recent status for for each carrier, it's only returning about 12 products of the most recent status for one carrier.

Any help would be much appreciated! Leave a message if you need more clarification.

Thanks!

 

[rainman89]

are their any blanks or nulls in the data? this could be causing your missing products

 

[washingtons]

Nope, doesn't work.

 

[boblarson]

Any possibility of posting the database so we can see for ourselves what is happening? (I'm way more visual and it helps me track down things much faster).

I realize that it may not be possible if the data is sensitive, but I thought I'd at least ask.