Recent content by Pullingmyhair

Thanks CJ_London. That did the trick!

The main table for the database I am working on contains the following fields: ID Mfr Control Number Initial or Follow-Up Follow-up Number Suspect Date of Initial Email Date Received Date Submitted Date of Report Serious Brief Description Causality Notes With some additional...

jdraw thank you so much for responding to my post! Sorry I am just getting back to this. I think I had been staring at my own database too long and wasn't very clear in my initial post. And your response actually made me give this more thought and realize I should be able to make this even more...

I am trying to accomplish something with a query that I thought would be fairly simple and instead seems not to be. Basically we have reports under a specific report number. Each report is required to have follow-up reports (under the same report number) so there is a field to indicate "initial"...