month formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Month Formatting

Month Formatting

resolvedResolved · Low Priority · Version 2007

Kate has attended:
Access Introduction course

Month Formatting

Can you format a date field to month field?

Edited on Sat 26 Jul 2008, 07:21

RE: Month Formatting

Hi Kate, Thank you for your post, formatting a date field to only display Month is quite straightforward.

In design view in the Form or Report, select the field and open the properties list, under Format type mmm for short month or mmmm for long month.

I hope that has helped, regards Pete


 

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips


Server loaded in 0.08 secs.