Addiing a column

[gdspeare]

I am addinng a column to my table. In an adjacent column, i have a date in the format mm/dd/yyyy. in the new column i want to have the month populate based on the MM of the adjacent column... what is the best way to do this?

help please

 

[Mudface]

If you can derive a column's value from an existing column, generally you would just do this in a query, not add it to a table. Start up a new query, add the table in question to it and use a Format function to convert the field with the date into a month (look up in Help for the syntax). You can then use this as the basis for any forms/ reports that you need. If you're not sure about any of this, please repost with the name of your table and the names of the fields within it.

 

[gdspeare]

I figured it out already... thank you for your help though

 

[gdspeare]

ok, new problem....how do i get a query to group by month and give me a count of the group. for example, if i have 50 records from the month of november - various days of the month, how would i ask access to tell me that?