How do you set a quary to only display data after a given date.

[zylosan]

I have a large table of data records. Each has a date field. I want to build a quary that only displays records with a date after XX/XX/xxxx. I figure that it should go in the criteria spot on the design view of the quary but don't know syntax.

[pbaldy]

>#XX/XX/xxxx#

[JoeM]

Assuming your data type is Date and not Text, just use the pound signs as your date qualifier, i.e.

> #11/10/2012#

[zylosan]

To clarify,

I am attempting to make a aggregate query that displays the average for each field in the table. I would like to be able to delimit some of the records (i.e. those before a given testing date) from the records that are averaged. I can do it by creating a sub-query that pulls up all the data records based on the date and than running an aggregated query on that. Is there any way to do it directly in my aggregated query?

[pbaldy]

Have you tried the above? Including a date criteria should exclude those records.

[zylosan]

I am using the totals bar on the query design view page. It does not work with out a value in the totals box but if I choose group by it displays each set of records that fall on a given date rather than the average of all the dates falling after that date.

[JoeM]

For your criteria field, choose the value of "WHERE" on the Totals line. Then it only uses it for selection purposes, and does not group by it.

[zylosan]

Thank you much. Problem solved.