Hi Happygv, both you and madhukp have helped me much more than I helped myself... I'm just doing the tweating part...

And you are absolutely right though... Initially, I have named the date fields in the database seperately for the Dates... But have already altered them...

Thanks again for the much needed advice... You guys are very friendly, I love this place a lot...

best regards,
Lawrence

Hi Helpme,

I am glad to see your topic is same like what i want now.
I not understand as below:

sql = "SELECT Field1,Field2,Field3,Field4 FROM Table1 WHERE MyMonth = " & MM & " and MyYear = " & yyyy

If my Access database column is date, i wonder how am i call out the month and year value. Can anyone help me?




apple

You wrap a function around it like:

sql = "SELECT DATENAME(MONTH,someDateTypeFieldName),Field2,Field 3,Field4 FROM Table1 WHERE MyMonth = " & MM & " and MyYear = " & yyyy & ";"

Of course 'SELECT DATENAME(MONTH,someDateTypeFieldName)' will give you the month name value from your stored date. Im sure you can work out how to get the year value based on what I have above.

FYI : You should have started a new post with a logical subject so others can benefit from your solution!!! Please do this next time?


Wind is your friend
Matt

Hi,

Thank you for your advice. I already issue a new topic name: Seek help for select Month list box.

By the way, can you explain for me

sql = "SELECT DATENAME (MONTH,someDateTypeFieldName),Field2,Field3,Field4 FROM Table1 WHERE MyMonth = " & MM & " and MyYear = " & yyyy & ";"

What is (MONTH,someDateTypeFieldName) means? I dont know apply to my coding. Hope to hear from you soon.

apple

Hi Matt,

Thanks for your help. I got it.
Have a nice day

apple