Modify query to display data that ends on or after a certain date?

[BBpatriotStorm]

I dont know if this question has been asked before but i need a quick answer to this problem:

The database is complete and i am in the query but i need to display contracts with a specific contract date ending on or after a certain date.

the actual step is this:
"Modify the Current lessons query to display all contracts that end on or after 7/1/2010."



i dont know why but i cannot seem to think straight right now!

[maximus]

Let me get this straight you have some data that you want to query with a date criteria.

Suppose you want to view data between two dates: Between #1/2/2010# And #1/12/2010# type this expression in the criteria of your date field in your query.

Now if you want to type the dates yourself without actually putting it in the criteria

Between [Type:Starting Date] And [Type:Ending Date]. Every time you run the query you will be prompted to type the Starting and the Ending Date. If you type the same date from both then data for that day will be displayed.

Please mark the thread if this solves your pronlem

[maximus]

have you been able to solve your problem if yes please mark this thread solved