Converting Date & Time into a Month

[HL]

Please Help!!!!!!!

I have created a database which works on information for a month, then at the end of the month it is transferred to a history table.

What I like to happen in the header of the form is to have a text box which will covert the first date which is entered into the table for example (02/02/2001 09:55:00) into a month

So for example the text box in the will say = "Total Number of Faults For The Month of " & [ Month]

The only problem I have is that I cannot change the Date / Time format because it is working out downtime between two dates & times

How do I convert it and where do I put the conversion?????

Thanks

HL

 

[Atomic Shrimp]

This ought to work:

= "Total Number of Faults For The Month of " & Format([YourDateFieldName],"mmmm")

HTH

Mike