ms access[tblmonthly - month, total]

month = lbldate [actually my date format is lbldate.Text = Date.Now.ToString("MMMMMMMMMM dd, yyyy") , im using this format for my daily sales and i can save and update at the same time, but in Monthly sales i want to use the same format but i want to save in field 'month' is only the month[MMMMMMMMMM] ,is it possible ? or should i use other format?

this is what i want in database[example]
January | 1000.00
February| 1900.00

To get month name you can use MonthName(Date.Now.Month) function, which can convert integer values 1 to 12 to their corresponding month name.

@Shark_1, thank you :)