I have a query that shows all jobs being worked on today and into the future ( > Date() -1). The problem I am having is when a job gets duplicated (for different versions or maybe a revision), the job shows up twice in this query, which I do not want.
Here is a snip of the design view:
However, the result is:
As you can see, the quote number 14763 has been revised once and is showing up twice. I would like it to only show up once with the max revision number, which in this case is 2.
What do I need to adjust to achieve that?
Here is a snip of the design view:
However, the result is:
As you can see, the quote number 14763 has been revised once and is showing up twice. I would like it to only show up once with the max revision number, which in this case is 2.
What do I need to adjust to achieve that?