Report HElp

[racerrunner]

Hi all,

Member Table
attribute: Name,Date Join,Email

* the format of my date is 23-Mar-04


How do i exact the 'month' from the date. eg 23-mar-04, the month will be mar.


The poutput of my report should be as follows, therefore i need to exact the month of the date, is there a way in access that can perfrom this. THANLK FOR THE HELP.


Member Report


Month : Mar
Name: Alan
Date Join: 23-mar-04


Name: Tom
Date Join: 26-mar-04


Month: Arp

NAme: Mike
Date Join: 05-Arp-03

Name: Wilson
Date Join: 23-Arp-05

 

[WayneRyan]

racerrunner,

Add a new column to your report's Query:

NewField: Format([YourDateField], "mmm")

Then you can use the new field for sorting/grouping.

That solution DOES NOT span years! It also does not order them
chronologically!

You can also look at the DatePart functon.

Wayne