var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Second Last Record?
I have a Query in which i get to the last record using a "flag" for eg an order reference has "n" number of orders and i check the details for the last order using a flag say ord_last="-1"
Now if the last order is a "certain type" another field, i want to check the second last record instead of the last.
Can i do it in a single query! i could not find any "If" constructs in MS access to do the same! can i avoid using multiple queries?
what about a descending sort? Just say SELECT TOP 2 ... ORDER BY ... DESC
Then you'll have the last one and the 2nd to last one.
I think Access supports the TOP phrase.