Yes, the command has two date parameters, to indicate a range. The subquery is independent of that, it should run for each record and has no relation to the overall dates.
And I have also written it with hard-coded dates, and the same thing happens.
I use Commands a lot. I could use SQL statements within a report using tables, but I want to use a command for a dynamic parameter (for something else) eventually, and that means SQL statements can't be used here.
I have ended up by grouping on the gov_link date, and putting it in the footer of that group so only the latest one shows.
But this is so inelegant.
And I would like to figure out why the sql is different for another time, which is bound to occur.
IP Logged
