Web Development



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