S
Schwimms
I have a query that I want to return results of "complete" if the same job
number has an Completipon date in all the lines that is taken up by the job
number, and an "incomplete" if not. This is what it looks like and I want the
Complete Column added:
Job # Date Complete?
400 1/2/08 Icomplete
400 Incomplete
400 Incomplete
405 1/3/08 Complete
405 1/10/08 Complete
410 5/7/07 Complete
410 3/10/07 Complete
410 8/9/06 Complete
415 6/5/06 Incomplete
415 Incomplete
Can you help me?
number has an Completipon date in all the lines that is taken up by the job
number, and an "incomplete" if not. This is what it looks like and I want the
Complete Column added:
Job # Date Complete?
400 1/2/08 Icomplete
400 Incomplete
400 Incomplete
405 1/3/08 Complete
405 1/10/08 Complete
410 5/7/07 Complete
410 3/10/07 Complete
410 8/9/06 Complete
415 6/5/06 Incomplete
415 Incomplete
Can you help me?