lneisius
Posts: 29
|
Posted: 03/03/2004, 10:21 AM |
|
I have a grid that displays events for the month and I would like to include a parameter in the sql where to reduce the amount of retrieved records. The field in the dbase is "StartDate" and I think it should look something like:
Month(StartDate) = Month(Date)
When I put this in the expression builder it adds quotations and looks like
"Month(StartDate) = Month(Date)"
Any ideas on how to properly do this?
|
|
|
kevind
Posts: 251
|
Posted: 03/03/2004, 1:42 PM |
|
When I get parameters I can't figure out the expression for, I create a database view instead - usually faster/easier.
Kevin
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|