var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to specify the "previous quarter"
Trying to make access only select data from the previous quarter. So far I have
Where Trans_Date... this is where I get stuck!
Any ideas? Have googled it and found nothing so far.
Where datepart("q", Trans_Date) = datepart("q", dateadd("q", -1, Now()))
Well that worked... sort of. It output the results of the previous quarter for both 2006 and 2005! How do I only make it 2006?
Another useful date function is Year([Date_Value]). Check it out in help and apply in the same way as Teddy outlined for quarter (make sure the year of the date matches the current year...).
ur codings are working excelent.