|  | Simple Month Calcuation in Query | | |
| | | Ron |  |
|  Posted: Sat Aug 23, 2008 10:22 pm Post subject: Simple Month Calcuation in Query |  |
Hi,
I have a list of transactions in my database that have a date associated
with the transaction. I'm trying to create a calculation in a query that is
basically the same as the Excel fuction of =Month(cellreference). Any
thoughts on how to structure this calcuation? I know in the expression
builder there is the 'Month' option; I'm just not sure how to use it.
Thanks, |
| |
| | | smartin | |
| | Posted: Sat Aug 23, 2008 10:39 pm Post subject: Re: Simple Month Calcuation in Query | |
Ron wrote:
| Quote: | Hi,
I have a list of transactions in my database that have a date associated
with the transaction. I'm trying to create a calculation in a query that is
basically the same as the Excel fuction of =Month(cellreference). Any
thoughts on how to structure this calcuation? I know in the expression
builder there is the 'Month' option; I'm just not sure how to use it.
Thanks,
|
The Month() function works the same way. Month(A_Date_Field) yields the
month number of A_Date_Field. Try it out. |
| |
|
|
