Re: Month Query
- From: "accessuser via AccessMonster.com" <u28669@uwe>
- Date: Tue, 07 Nov 2006 23:41:54 GMT
I dont know if this is me that can't get this to work or what. I TRIED what
you told me, over and over. I dont need YEAR, all i need is MONTH. I have
another field for YEAR. I tried to change the following so many times:
1) Table Design, Scheduled Month field to "Date/Time", under it, there is a
"format" i put "mmmm" or "mmm" neither worked. There is option that I can
select, but it is always with month and year, i dont need that, I only need
MONTH, that's all.
2) On the query designed, I changed the field "format" to "mmmm" or "mmm",
neither worked. And I also copy and paste the expressions that you two
provided. Still no luck.
3) I changed my "scheduled month" column on my form to "Date/Time", format
"mmmm" or "mmm", it doesnt work.
And it keeps giving me the error message of it is invalid, and too complex.
I really want this to work as Date, but I can't make it work.
Choose([Scheduled Month], "January", "February", "March", <etc through
December) <<<<<<<<Where do I put this???
John Vinson wrote:
I tried with the codes that you provided and just couldn't figure out. But I[quoted text clipped - 3 lines]
tried using my Scheduled Month format as "number" in the table design. And
using the "number" format. Is there any way at all? I just can't get them
to work by using the tips you two provided.
Sure. You can use an integer 1-12 field [Scheduled Month] and use a
function:
Choose([Scheduled Month], "January", "February", "March", <etc through
December)
You DIDN'T use the tips I provided. I suggested changing the datatype
of the field to Date/Time. Did you try that?
I am also thinking of doing it by formating
Don't confuse a field's DATA TYPE with its FORMAT. They are two quite
separate (somewhat interdependent) properties. A Format merely
controls how a value is displayed; a datatype controls what can be
actually stored in the field.
the Scheduled Month field as
number format, and then use combo boxes in the forms with 2 columns, one
number, and another month name, and on the report side by using a formula of
=scheduled month? WIll this work? Will it mess up some calculations in the
future?
Yes. What year is 4 in?
Date values ARE DATES. January follows December (if it's January 2007
and December 2006); 12 follows 11 and precedes 1. This is true of
dates; it is NOT true of numbers. If you're working with date data -
why on Earth don't you want to use a date datatype!?
Any easy way for me to do this month query, i am not an expert in access and
is getting very frustrated with this month query. If possible, is there any
possible access samples with just Month Query. I checked out the Allen
Browne, but couldn't figure out at all with that code.
It's not working because you are insisting on using THE WRONG
DATATYPE.
John W. Vinson[MVP]
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200611/1
.
- References:
- Month Query
- From: accessuser via AccessMonster.com
- Re: Month Query
- From: John Vinson
- Re: Month Query
- From: accessuser via AccessMonster.com
- Re: Month Query
- From: John Vinson
- Month Query
- Prev by Date: Re: inputing calculations
- Next by Date: Re: Subform doesn't appear when printed
- Previous by thread: Re: Month Query
- Next by thread: Go To Control
- Index(es):
Relevant Pages
|
