Recent content by shawnf

You seriously just made my day!!!!!!!!! I wish I could understand all that is going on here, but what I do know is, it works! I hate even asking because I cannot imagine the amount of time you have put into this for me...and I seriously cannot thank you enough...but if there is a PN that...

Yes I am sure Those dates do not match the PNs. I was looking over the code and although my understanding of VB is limited I feel like it has to do something with the counter. I just left it as C and I am not sure where the info for the initial value of C comes from. I also do not know how to...

Thank you arnelgp for the response, I feel as if I am getting closer to the desired results. I used the code, and it runs without bugs except it outputs the same date in First Count all the way down, same with Second Date and Third Date...the Forth Date column is empty, as I would expect it to...

I have changed it to include my field names. I have attached images of the SQL and the final error I am getting. I appreciate the help so far. If I could get this to resolve that would be amazing.

Running Sub2 asks for Parameter. "Enter Parameter Value, TimesCounted_sub1_1.CountDate" running final query gives error "The specified field 'TimesCounted_sub1.CountDate' could refer to more than one table listed in the FROM clause of your SQL statement

Thank you so much, I will try this out. And I do not have spaces in my headers. this was a quick model of what I have in the actual database. I will let you know if this works!

I have a table like this PN COUNT DATE ABC 1/18/2016 ABC 1/20/2016 ABC 5/5/2016 XYZ 1/12/2016 XYZ 1/18/2016 XYZ 5/10/2016 HIJ 1/8/2016 HIJ 1/12/2016 All PNs have to be counted 4 times a...