Count the number of records in results of a query

[jfiresto]

I have a Table called Dates in this table I have three fields Date_ID, Customers and Date_1



I have a query that sets the date range I am searching what I want also is to give me a count of the results from the query. I have attached a copy of my query in SQL I am using Access 2010. I hope this is clear as to what I want, I hope some one can help, I am lost at this. What do I need to add or change ?

SELECT Dates.Date_1
FROM Dates
WHERE (((Dates.Date_1) Between [what start date:] And [What end date:]));


Thanks in advance
John

[Rod]

Read up on DCount.

[jfiresto]

I just read about DCount and now I am totaly confused as to what to do.

[Rod]

How/where do you want to use/display the count?

[jfiresto]

in a message box

[Rod]

Actually I need the whole story: how do you invoke the query; are you going to run the query and get the count simultaneously; are the start and end dates known/stored somewhere or are they entered each time the query/count is run?

[jfiresto]

Right now I will just select the Query and run it. The query will ask me to enter a start and end dates which I will enter. The query would then come back with the query/count.

[Rod]

This will give you a count:

SELECT Count(Date_1) AS CountOfDate1
FROM Dates
WHERE (((Dates.Date_1) Between [what start date:] And [What end date:]));

[jfiresto]

Thank you so much, this was driving me crazy.

Thank you
John from California