How to group crosstab query date header weekly? Expr1: Format([.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a cash flow analysis which I successfully grouped monthly by using
for the column header the following expression Expr1: Format([Check
Date],"mmm") and now would like to do weekly.

I tried substituting "WW" for "MMM" as this seems appropriate for reports
but it does not work. I note that there also appears to be a GroupOn
function that permits summarizing Data Access Pages week. I do not know
either visual basic or SQL so I don't really know what a Data Acces page is
or if it can be used in this case.

I need a simple solution to group weekly and additionally if possible
semi-monthly'
 
Format([DateField],"ww") should always work. When you state "it does not
work" in a news group posting, you should provide more information. Can you
provide some symptoms?
 
Back
Top