parsing dates

  • Thread starter Thread starter klp via AccessMonster.com
  • Start date Start date
K

klp via AccessMonster.com

If I want to do an expression in a query that depicts data for a month how do
I do that? I do not want to have to put in a year because that will be
determined by what date is selected on the form and then that information
will print on the report. Let me further explain.

I want to say If [MyDate] = "Jan" then GiveTotalForMonth. want to do that for
each month.

I've seen things to filter the dates but I have to put in a year. The year
end will change so I just want month.

thanks in advance.
 
If you want to limit the data that is returned to just one specific month.

Month(MyDate) = 1

Add a calculated column and set it to
Field: MonthNum: Month(MyDate)
Criteria: 1

If you want to do something different please try to rephrase your question.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
No this is exactly what I want. I did what you said but when I put the
criteria in it just displays that number. So if I put in 5 for May it
displays 5. What am I doing wrong?

John said:
If you want to limit the data that is returned to just one specific month.

Month(MyDate) = 1

Add a calculated column and set it to
Field: MonthNum: Month(MyDate)
Criteria: 1

If you want to do something different please try to rephrase your question.
If I want to do an expression in a query that depicts data for a month how
do
Click to expand...
[quoted text clipped - 10 lines]
thanks in advance.
Click to expand...
Click to expand...
 
Please disregard, if I would've took a few extra minutes to see what I was
actually doing I would've figured that out. Thank you so much for the input!
No this is exactly what I want. I did what you said but when I put the
criteria in it just displays that number. So if I put in 5 for May it
displays 5. What am I doing wrong?
If you want to limit the data that is returned to just one specific month.
Click to expand...
[quoted text clipped - 11 lines]
Click to expand...
 
Back
Top