Web Development

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!



Preventing Certain Dates from appearing in a report.

By Lonas1127 ·
I have a db that I regulary need to delete similar dates from a table so that a report appears correctly. The db was set up by a person that no longer works here and contains an "update query" and a "delete duplicates query". The problem is that when a job has been completed the db is supposed to enter a new Cpmpletion date for when the job needs to be done again. For example: Maintenance on a machine is done on a Yearly basis, if the job is completed on 5/12/2012, the next time that the same job needs to be completed would be 5/12/2013, but the report consistently is showing the 5/12/2013 date as well as another date, like 5/30/2013. So, it isn't exactly "duplicating" the data it's adding more. any ideas of how I coukld prevent the extra dates from appearing?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums