Date Problems

  • Thread starter Thread starter Derek Brown
  • Start date Start date
D

Derek Brown

Hi all

any one know to show (in a query) the first date of any selected calander
week number?
 
Derek

Take a look at the Min() aggregate function available in a query via the
Totals query.
 
Thanks Jeff

The query is a basis for a "Weekly"diary.There are not always appointments
for Sunday (First day of week). But I need to create a lable for the heading
of the subreport Sunday which includes the date.* This is so that when the
diary is printed Sunday and the date for that Sunday can still apear if only
to confirm that there are no apointments for Sunday.

*If I put a label in the Subreport for Sunday and Subreport Sunday HasNoData
the whole report is invisible.
 
It sounds like you might be able to use a Cross-Tab query to "force" a
Sunday category, even if no data exists. Alternatively, could you use the
Nz() function to return a zero (0) when there are none for Sunday?
 
Back
Top