var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to reference the last record in a table
1) I have a table called "Flyer" with fields FlyerId, FlyerYear, etc. The most current flyer would have the last (the biggest number) FlyerId.
2) I also have a query with control FlyerId, however not taken from Table "Flyers", but from another Table. I want to run the query with FlyerId = Most current record from Table "Flyer".
All this is in MS Access, not VB. I tryed to put in the query condition Max([Flyer]![FlyerId]) but it did not work.
I hope my explanations are clear and someone could help solve this annoing issue.
= ( select max(FlyerID)
from Flyers )