Forums
This topic is locked
Why does this not work
Posted 04 Feb 2004 23:07:25
1
has voted
04 Feb 2004 23:07:25 stuart purvis posted:
Why doe s this not work.It gets sent a value depenviewbygroup.Source = "SELECT calDate, EventDetails, YearGroup FROM Calendar WHERE YearGroup = '" + Replace(viewbygroup__MMColParam, "'", "''" + "' AND calDate >=Date() ORDER BY calDate ASC"ding on what button users clicks it should then show only those records from todays date.
But its SHOWS NOthing at all if i take out date statement it show all records with what ever value is passed