Update Query Dependent on the month

[hawkins]

I have two tables, one called Yearly which is the table that is going to be updated and has 3 columns for each month used, and a Initial table which has rows for each feeder and month, for example there are 4 rows for each name because of the year is split into 4 portions. The date is in the Initial table and is Field3 and comes in the form 01-15-2010. I was wondering how I can update those three columns depending on the month? If you can explain it in the design view that would be a lot better because I am still not too familiar with SQL.

[jgelpi16]

Have you tried using the DatePart() function to extract the month from your date? I would recommend you do some research on DatePart() to see if that is what you're trying to accomplish.

[hawkins]

thanks for the help, that was exactly what i needed!

[jgelpi16]

Glad that helped!