Combine Format function?

  • Thread starter Thread starter AccessKay
  • Start date Start date
A

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
 
Of course this worked...Thank you!


Jerry Whittle said:
In a query:

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


AccessKay said:
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
Click to expand...
Click to expand...
 
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
 
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

Marshall Barton said:
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.
Click to expand...
.
Click to expand...
 
Back
Top