Ordering

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hi,

I have a report which is based on a table called tblStreetSweeping and
has the fields (Date, TicketNo, Type & Weight). Each finacial year
runs from April to March, the data in the table ranges from April 2006
to July 2007, in my query I have the formula SortMthNum:
Month(DateAdd("m",-3,[Date])) but it just takes in to account the
month and not the year, How do i get the data to be sorted in the way
it displays it April 2006, May 2006, June 2006, july 2006 all the way
thru to july 2007 .
In each month I would like the data broken to the actual pick up day
i.e Monday, Tuesday, Wednesday etc. In my query I have the formula
Day: Format([Date],"dddd") but when I run the report it sorta it
alphabetically, how do you get it to order it Monday, Tuesday,
Wednesday etc?

Confused!!
Fie
 
Answered in Reports.

(Please do not post multiple separate copies of the same question to
different groups.)
 
Back
Top