I'm trying to run a parameter query so it asks for a date between and a date to end and then to display all the results in grouped for on a report.
thanks to healdem earlier he gave me help on the sql query. Now though when i add a parameter to the query healdem made in design view (BETWEEN [START DATE] AND [END DATE]) it shows every result and counts them as one so you get all the records brought back as individual records if the date is different.
this is the sql code healdem wrote:
SELECT mytable.source, count(mytable.source) as NoContactsBySource
group by mytable.source
If you look at the SQL created when you added that, it probably added the field to both the SELECT and GROUP BY clauses. You just want it in the WHERE clause. In design view, you can achieve that by changing GROUP BY to WHERE.