I'm trying to the number of records that are from the same month in an Access report. The query pulls data from two tables, and uses the month funtion to identify which month the record was added. Can I set up the report so when the user enteres 6, the report counts the number of responses from June only? I can only get this to work with the 6 hard coded into the formula:

=DCount("[MonthCompleted]","Master Data Export","[MonthCompleted] ='6'")

I have used the brackets in the past to ask [What month?], but when I add this where the 6 is I either get an error or 0.

Anyone know how I can get this to work?

Thanks for your help!