Combine Format function?

[AccessKay]

Hi,

I have a field called TransDate that is in the format 01/01/2010 and I want
it to look like 2010Jan. Is there some way to combine the Format function or
should I be using some other function?

Thanks for the help,

Kay

 

[Jerry Whittle]

In a query:

YearMonth: Format([TransDate], "yyyymmm")

 

[AccessKay]

Of course this worked...Thank you!

In a query:

YearMonth: Format([TransDate], "yyyymmm")
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi,

I have a field called TransDate that is in the format 01/01/2010 and I want
it to look like 2010Jan. Is there some way to combine the Format function or
should I be using some other function?

Thanks for the help,

Kay

 

[AccessKay]

Thanks Marshall. I appreciate the additional information. I read in my
books that it’s easier to set everything up first in a query before you do
the report but now I’m learning that this is not always true.

Kay

 

[AccessKay]

Thanks again! I really appreciate you taking the time to expand on this. I
often have problems with “the big pictureâ€. This understanding is a big help
to me.

Kay

No, it is true. It's the definition of "everything" that's
in question. The "everything" for a report (and most forms)
is to create a query that retrieves the appropriate fields
on all the needed and only the needed data records.
Calculations that involve information from more than a
single record, except for most aggregations, also should be
done in the query.

Formatting the field values is only done for display
purposes and should be as late in the game as possible
(typically a text box's Format property and rarely as early
as the query). Sorting, grouping and other non-trivial
formatting should also be done in the report.
--
Marsh
MVP [MS Access]

Thanks Marshall. I appreciate the additional information. I read in my
books that it’s easier to set everything up first in a query before you do
the report but now I’m learning that this is not always true.

.