J B via AccessMonster.com said:
In my table I have NextDueDate I want only the current Next Due Date to
display in my report page header how do I accomplish this?
If we only knew what determines the "current Next Due Date", we could help
better.
If that is defined as the Record with the least next due date that is
greater than or equal to today's date, the WHERE clause of your query might
read [NextDueDate] > Date(), with an ORDER BY clause of NextDueDate, and
using the TOP 1 option in the Query Properties.
That query's SQL might look something like:
SELECT TOP 1 * FROM yourtable WHERE [NextDueDate] > Date() ORDER BY
NextDueDate
If you'll copy that, change the table and field names to yours, and paste it
in to the SQL View of a Query, it may be easier to work with the Query
Builder.
Larry Linson
Microsoft Access MVP
