Filter Query to another table

[ali32j]

Hi ALl

I am using the following SQL in a query, which filters to user, but seems it looks at the bottom 25 of the whole table not the filtered table


SELECT BusinessWarehouseMonth.[Ship To], BusinessWarehouseMonth.Territory, BusinessWarehouseMonth.Delta, BusinessWarehouseMonth.[Period Yr-1], BusinessWarehouseMonth.[Period T/O], BusinessWarehouseMonth.[FY-1 Full Year], BusinessWarehouseMonth.[FY-2 Full Year]
FROM BusinessWarehouseMonth
WHERE (((BusinessWarehouseMonth.Delta) In (select top 25 delta
from businesswarehousemonth
order by delta asc)))
ORDER BY BusinessWarehouseMonth.Delta;

Is there anyway to show the bottom 25 of the filtered records?

Ali

 

[dhookom]

Does this work?

SELECT BusinessWarehouseMonth.[Ship To], BusinessWarehouseMonth.Territory, BusinessWarehouseMonth.Delta, BusinessWarehouseMonth.[Period Yr-1], BusinessWarehouseMonth.[Period T/O], BusinessWarehouseMonth.[FY-1 Full Year], BusinessWarehouseMonth.[FY-2 Full Year]
FROM BusinessWarehouseMonth
WHERE (((BusinessWarehouseMonth.Delta) In (select top 25 delta
       from businesswarehousemonth
order by delta DESC)))
ORDER BY BusinessWarehouseMonth.Delta;

Duane
Hook'D on Access
MS Access MVP