|
-
June 4th, 2003, 02:39 AM
#1
help please!
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|