Today I was practicing shooting some dead wildflowers against a backdrop of a moving stream. My objective was to keep the wildflowers in crisp focus & allowing the moving water to blur the background creating a fluid negative space. I was using a Canon 400d with a Canon 100mm f/2.8 macro lens. Lens-to-subject distance was about 12" - 18". I was focusing manually with mirror lockup on a tripod.
Even at f/22 I was unable to capture the subject is crisp focus. Was this because the lens-to-subject distance was too short? I would really appreciate some guidance here. Thank you for your help.

