Report generation

[priyam]

Hi i have attached a word file in this post please have a look at it and let me know if any body could help,i would be really greatful.

Its about a report generation tool on which i am working,i have to retrieve data from database between 2 specified dates,but i am unable to do it even by using between clause

Please help

[sayfrndship]

Do convert your field to datetime format datatype. and try this

select * from report where dt between #08/01/2008# and #08/31/2008#

[priyam]

Thanx for your help...but i have figured out the actual problem.
The data in my database is stored in the format m/dd/yyyy and my search string contained date in mm/dd/yyyy for e.g date in database is 8/01/2008 but i was searching for 08/01/2008..the problem was with the format of the month.

[sayfrndship]

Is it got alright now ?

[priyam]

Yes :)