Skip to Content
0
Former Member
Mar 05, 2009 at 12:06 PM

Query Generator in SBO 2007

17 Views

Hi

I need to write a query based on sales orders but there are quite a few criteria

The user wants the ability to enter a date range, order number range and business partner range

The query I have is I want the report to produce all info if they leave the criteria blank

I am not sure how to do this.

Not sure if I need to use some sort of IF statement which basically says if a BP range has been entered then use it else ignore it, etc

Can anyone help me please ?

Thanks

Regards Andy