Bi monthly query in Access
Posted on 2003-10-24
I have developed a "property management" database in Access 2000 and I need help developing one query. Here is the situation:
I work for the U.S. Marshals Service in the Asset Forfeiture Program. We are responsible for maintaining real estate seized by the DEA, FBI etc until a judge says we can sell it. We currently have a private contractor that provides property management for us and my database will be used to keep tabs on the contractor. I need help developing a query that will show all applicable records every two weeks from the date they were entered in the database. For example, if I place an order for property management with the contractor I enter that order in my database. Based on that order the contractor provides property management (grass cuts, security, etc) every two weeks until I cancel the order. What Im trying to do is have my system prompt me every two weeks from the date I ordered property management so I can check to make sure the work is being done. Thanks for any help you can provided. Ive never used this system before so I am including my phone number in case I need to explain further. Thanks again!