Adding Month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

does anyone know how to add the month ( January, February ETC....) to a table by using a update query and a short date feild from the table - example date is 1/2/04 and I want to show that the month is January in a different feild on the same table - Thanks in advance - Bry
 
Hi Bry,
This should work for you. In design view of table,
create new column to hold the month.
Create new query, select new column. Change to update
query. Type the following in the update to: field

Format([shortdatefield],"mmmm")
-----Original Message-----
does anyone know how to add the month ( January, February
Click to expand...
ETC....) to a table by using a update query and a short
date feild from the table - example date is 1/2/04 and I
want to show that the month is January in a different
feild on the same table - Thanks in advance - Bry
 
does anyone know how to add the month ( January, February ETC....) to a table by using a update query and a short date feild from the table - example date is 1/2/04 and I want to show that the month is January in a different feild on the same table - Thanks in advance - Bry
Click to expand...

There is no need and no benefit to adding a redundant column for this
purpose!

Just create a Query based on your table; add a calculated field

Format([datefield], "mmmm")

This will now contain the month as a text string, sortable
(alphabetically, April, August, ...), searchable, etc.
 
Back
Top