View Single Post
  #1 (permalink)  
Old January 7th, 2008, 07:32 AM
mateenmohd mateenmohd is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default date between clause

I use following query to preview the records.
but it only one date ask and display the records


SELECT WORK_LOCATION.*
FROM WORK_LOCATION
WHERE PROPOSED_STR_DATE between [] and [];

how can use / run query in access that it ask two date and
then display the records ?

when I use only one date ie.
where propose_Str_date=[] then it is ok

I want to display records by two date how ?

what will be query syntax ?

Thanks
Mateen