Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
funkkube
Starting Member
8 Posts |
Posted - 2004-10-10 : 20:01:01
|
HIAny ideas what is wrong with this?the values startdate and enddate are fom combo boxes.SELECT visits.* FROM visits WHERE (([visits.visitdate] BETWEEN '"#& Me.startdate.Value #"' AND '"#& Me.EndDate.Value #"')) AND (([visits.repname])='Peter'); |
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-10-11 : 01:58:00
|
I don't know access but I know a bit of VB - I think this might work..[CODE]"SELECT visits.* FROM visits WHERE (([visits.visitdate] BETWEEN '#" & Me.startdate.Value & "#' AND '#" & Me.EndDate.Value & "#')) AND (([visits.repname])='Peter');"[/CODE]Duane. |
 |
|
funkkube
Starting Member
8 Posts |
Posted - 2004-10-11 : 05:52:18
|
Hino joy!get method or data member not found.. |
 |
|
|
|
|