The query below produces the correct results, for the entire table! I need a date range selection included.
I need to know how to allow the user to enter a date, ie. [Enter yyyy-mm] and have it placed in the three date fields before the query is run so it includes the date range to selet with. Am I making sense here? This would clinch it.
The three date fielda are formated as yyyy-mm-dd 00:00:00
Any suggestions . . . ? THANKS MUCH . . .Rick
SELECT OCDownloadRES.CITY,
Count(OCDownloadRES.LISTDATE) AS CountOfLISTDATE,
Count(OCDownloadRES.PENDINGDATE) AS CountOfPENDINGDATE,
Count(OCDownloadRES.CLOSEDDATE) AS CountOfCLOSEDDATE
FROM OCDownloadRES
GROUP BY OCDownloadRES.CITY, OCDownloadRES.PROPSUBTYPE
HAVING (((OCDownloadRES.PROPSUBTYPE)=[ENTER PROP TYPE]));
I need to know how to allow the user to enter a date, ie. [Enter yyyy-mm] and have it placed in the three date fields before the query is run so it includes the date range to selet with. Am I making sense here? This would clinch it.
The three date fielda are formated as yyyy-mm-dd 00:00:00
Any suggestions . . . ? THANKS MUCH . . .Rick
SELECT OCDownloadRES.CITY,
Count(OCDownloadRES.LISTDATE) AS CountOfLISTDATE,
Count(OCDownloadRES.PENDINGDATE) AS CountOfPENDINGDATE,
Count(OCDownloadRES.CLOSEDDATE) AS CountOfCLOSEDDATE
FROM OCDownloadRES
GROUP BY OCDownloadRES.CITY, OCDownloadRES.PROPSUBTYPE
HAVING (((OCDownloadRES.PROPSUBTYPE)=[ENTER PROP TYPE]));