Share via

how to I modify a query by adding a condition

Anonymous
2016-04-22T23:25:55+00:00

How do I modify a query by adding a condition to my start field to select records with contracts that begin ON OR AFTER March 1 ,2016

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-04-23T00:35:29+00:00

    Have you tried setting a criteria of:

    >=#3/1/2016#

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-04-23T00:42:29+00:00

    That sort of depends on how the query is set up now - which we cannot see. Daniel's suggestion is, of course, probably all you need, and if the query is relatively simple you should be able to just put that expression on the Criteria line under the date field in query design view. If the query isn't simple, or you're adding this criterion as another one of many, please open the query in SQL view and post the SQL text here.

    Was this answer helpful?

    0 comments