Ordering

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
 
A

Allen Browne

Answered in Reports.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top