Web Development



query criterion: DateAdd, Microsoft Access 2007

By aburgin56 ·
I need to place an expression in the criteria row that will return a range of the last six months of ship dates. The expression is DateAdd("m",-6,[anotherquery]![MaxOfShippedDate])

The other query has the field of 'MaxOfShippedDate' where a total row showing max is present. I am not supposed to figure out what these date ranges are. The expression is supposed to tell me this.

The return that I get is a blank row with no data in it.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums