Hi Paul, such an improvement. The time fields are populating now with the correct format. There are two other time fields (lights on and lights off) in this report that will need to be changed as well once I learn how.

As I had mentioned earlier, I have to create 5 more similar reports, so a quick lesson on the magic you performed will be most helpful in accomplishing this task. I took a quick peek at your report, but didn't want to play around too much for fear of screwing up a good thing. I believe I saw an "IF" in the time fields.

Next mission ... take the "header" and "footer" tables out of the document header and footer and place in the main body in an effort to create a directory type final document.

As always ... thank you for your patience and dedication to see these problems resolved.