Cannot format a date in Query- returns a blank

[Guest]

In Access 2003 i want format a date field to "mmm"", = Jan or Feb. However
the format function return a "blank field"

 

[John Spencer]

You didn't post what you tried. Assuming that you tried the following

Field: TheMonth: Format([TableName].[FieldName], "mmm")

And that did not work, then I might try checking your references to see if
any are marked as missing.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Many thanks John,

I did exactly as you typed, also did check for missing references, but
nothing showed up! I also tried to convert a data base that is working fine
in Acc 2000, but it still is not working correctlty! Please truy and help,
thanks in advance.

You didn't post what you tried. Assuming that you tried the following

Field: TheMonth: Format([TableName].[FieldName], "mmm")

And that did not work, then I might try checking your references to see if
any are marked as missing.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

In Access 2003 i want format a date field to "mmm"", = Jan or Feb. However
the format function return a "blank field"

 

[raskew via AccessMonster.com]

Hi -

As an experiment, try this from the debug (immediate) window and let us know
what it returns:

'today's date = 29-January-2007

? format(date(), "mmmm")
January

Does it return "January"? If not, you've got a reference problem.

Bob

Many thanks John,

I did exactly as you typed, also did check for missing references, but
nothing showed up! I also tried to convert a data base that is working fine
in Acc 2000, but it still is not working correctlty! Please truy and help,
thanks in advance.

You didn't post what you tried. Assuming that you tried the following

[quoted text clipped - 5 lines]

 

[Guest]

Bob,
"January" was indeed returned. The problem is now solved, initially the
database showed the following error when converted "msowc.dll" reference
missing. I was never saw this message and started to work - well long story
cut short, I deleted the tick mark now and it worked. (I'll never work on a
opened database again!!!)

Many thanks
Werner

Hi -

As an experiment, try this from the debug (immediate) window and let us know
what it returns:

'today's date = 29-January-2007

? format(date(), "mmmm")
January

Does it return "January"? If not, you've got a reference problem.

Bob

Many thanks John,

I did exactly as you typed, also did check for missing references, but
nothing showed up! I also tried to convert a data base that is working fine
in Acc 2000, but it still is not working correctlty! Please truy and help,
thanks in advance.

You didn't post what you tried. Assuming that you tried the following

[quoted text clipped - 5 lines]

In Access 2003 i want format a date field to "mmm"", = Jan or Feb. However
the format function return a "blank field"