What is wrong with this? - SQL Server Forums

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.

All Forums

Other Forums

MS Access

What is wrong with this?

Author

Topic

funkkube
Starting Member

8 Posts

Posted - 2004-10-10 : 20:01:01

HI

Any 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

Hi

no joy!
get method or data member not found..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources