Hi!
Just change the join condition from using InvNo to use the date. I already posted updated query.
>Hi,
> Yes, I tried. However, it works ASC. It get the earliest invoice first rather than latest. Any ideas?
>
>Thank you
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.