ArffMarine
Technical User
I have a table titled TestAnalysis
This table stores information on the number of students in a class who missed questions on two seperate exams. The exams are administered to the students on two seperate dates. Each quarter we analyze the number of missed questions to validate our tests.
What I would like is to have a form that runs an aggregate query that only returns the records between two dates enterd on an unbound form that runs the query.
I am having a problem with the criteria in that I don't know what to put for the criteria.
I tried
Between Forms!QuarterlyTestAnalysis!Start and Forms!QuarterlyTestAnalysis!End
With this criteria i get no results in my query.
I also tried
Between DateValue [Forms]![QuarterlyTestAnalysis]![Start] and DateValue [Forms]![QuarterlyTestAnalysis]![End]
again, With this criteria i get no results in my query.
I finally tried
Between #Forms!QuarterlyTestAnalysis!Start# and #Forms!QuarterlyTestAnalysis!End#
But it gets kicked back as an incorrect date function
The fields I need to query are DateMidBlocked and DateEndBlocked
The form i am using to run the query is titled QuarterlyTestAnalysis and the field the dates are entered are titled Start and End
Please advise.
This table stores information on the number of students in a class who missed questions on two seperate exams. The exams are administered to the students on two seperate dates. Each quarter we analyze the number of missed questions to validate our tests.
What I would like is to have a form that runs an aggregate query that only returns the records between two dates enterd on an unbound form that runs the query.
I am having a problem with the criteria in that I don't know what to put for the criteria.
I tried
Between Forms!QuarterlyTestAnalysis!Start and Forms!QuarterlyTestAnalysis!End
With this criteria i get no results in my query.
I also tried
Between DateValue [Forms]![QuarterlyTestAnalysis]![Start] and DateValue [Forms]![QuarterlyTestAnalysis]![End]
again, With this criteria i get no results in my query.
I finally tried
Between #Forms!QuarterlyTestAnalysis!Start# and #Forms!QuarterlyTestAnalysis!End#
But it gets kicked back as an incorrect date function
The fields I need to query are DateMidBlocked and DateEndBlocked
The form i am using to run the query is titled QuarterlyTestAnalysis and the field the dates are entered are titled Start and End
Please advise.