help please!

[kjcarrots]

hello experts!

i think this query works fine but the results returns a date that is NOT between January and March....

is there something wrong with my query??

Data1.RecordSource = "Select publisher, address, postalcode, tel, fax, isbn, publication, author, edition, l_used, b_used From isbn Where format([Date], ""yyyy"") = '" & year.Text & "' AND Format([Date], ""mmm"") between 'Jan' and 'Mar' order by publisher"

Thankies!!

Joy

[ITGURU]

Hi kjcarrots,

Please replace your query with following:

Data1.RecordSource = "Select publisher, address, postalcode, tel, fax, isbn, publication, author, edition, l_used, b_used From isbn Where YEAR([Date]) = '" & year.Text & "' AND (MONTH([Date]) between 1 and 3) order by publisher"

Hope this will solve your problem.

[Pinky98]

for your purposes, better than the MONTH command is the MONTHNAME command.

[kjcarrots]

Thanks guys for the help!

JOY