OK, so I named a hidden parameter and defaulted the value to the query field. That seems to work.

thanks.....

I don't want to post the whole query but this section prevents anything other than a date stored as a varchar:

t_UserExtended_1.ue_ControlName = 'PO_InvoiceDate'

That's the join I was alluding to when...

Yes, it's ugly but it's what I have!

Unfortunately, using ISDATE doesn't fix my problem.

AND (t_UserExtendedValue_1.uv_Value >= @InvStartDate)

ISDATE returns an int value to indicate if it's a date or not. ...

Thanks Jack,

You're preaching to the choir, my friend! I agree entirely but,...

Yes, I've checked that. Neither the dataset name or field has changed (or at least, not changed explicitly). The only change I've made is to place my tables...

I still have a problem with my report. I have several tables within a parent table as suggested but some of the datasets aren't found by the report. ...

Thanks for the reply. It's not very encouraging but c'est la vie.

Yes, that works. Thanks!

Thanks Jack,

Yes, that's it.

thanks,

Paul

Thanks,

Actually I already did it. It was a lot more straightforward than I thought it was going to be. I just dragged an image to my report pane...

I just tried exporting it to Word which seems to be what I need...

Thanks Bob,

Yes, it's funny how that happens but it's always good to ask around and there's no better place to ask than this forum.

I'm on a few forums but there's...

I'll try these options .....thanks....

OK, I've used 'CountRows' specifying year, month and day (excluding variable hh:mm:ss)