Find First and Last in Sequential Numbers (1 Viewer)

[sneuberg]

Attached is another version which contains the working queries. I've added a report for plog's queries to the form so you can test both solutions from there.

 

[tl mike]

sneuberg and plog

THANK YOU FOR REPLYING and sorry it took so long to get back.

For some reason my automatic emails for replies to this subject never cam through so I was figuring you were just busy and didn't have time to really look at it yet.

I will review the suggestions and get back to you ASAP if I have any issues.

THANKS AGAIN!!

 

[tl mike]

I've attached a revised version of my solution. My previous version had the Part Number and Year interchanged in the output table.

This also includes plog's queries which I have not been able to get working.
@plog Would you take a look please?

This version works the way that I need it to. I will see how to implement it into our current db and see if I get stuck or have any questions. Once finish I will post it back for others to use.

Thanks again.