Crosstab Criteria or Parameters

[lukewarmbeer]

(Access 2007) I have created a crosstab query with times for row headings and names in the column headings. I am trying to set the criteria to pull information for the value from a specific date. It will not allow me the set a criteria at all and when I set the parameters, it asks for the date, but still lists all values from the query and not just that of the specified date. Any ideas of what I am missing?

[NTC]

you could try this; make a regular query that serves the role of defining the records set by specific date. In this first query you use criteria to define the date.

then, resource your crosstab query to use this first query as its record source.

[lukewarmbeer]

I did try that. It did not work either. It does not accept the "Criteria".

[lukewarmbeer]

I set a parameter and criteria and now it works!