I have this criteria in my select statement but data is not returning as it should : basically where I state ainvhead.salesman = "2" it's not pulling this data - any help would as usual be great!

 

{ainvdet.layout_section} = "D" and
{ainvdet.invoice_date} in {?Date from} to {?Date to} and
{ainvhead.salesman} like ["*67*", "*75*", "*76*", "*78*", "*79*", "*83*", "*85*"] and
{sysuser.job_description} = "Customer Services Advisor"
and not ({ainvdet.part} startswith ["SMP", "LEA", "ABC"])
and if {?Selection} = "Group" then {ainvdet.product_group} = {?Group}
else if {?Selection} = "Family" then {stock.price_family} = {?Family}

or

{ainvdet.layout_section} = "D" and
{ainvdet.invoice_date} in {?Date from} to {?Date to} and
{sysuser.job_description} = "Customer Services Advisor" and
{ainvhead.salesman} = "2"
and not ({ainvdet.part} startswith ["SMP", "LEA", "ABC"])
and if {?Selection} = "Group" then {ainvdet.product_group} = {?Group}
else if {?Selection} = "Family" then {stock.price_family} = {?Family}

Try this:-

 

{ainvdet.layout_section} = "D" and
{ainvdet.invoice_date} in {?Date from} to {?Date to} and

({ainvhead.salesman} like ["*67*", "*75*", "*76*", "*78*", "*79*", "*83*", "*85*"]  OR {ainvhead.salesman} = "2")

 

and {sysuser.job_description} = "Customer Services Advisor"
and not ({ainvdet.part} startswith ["SMP", "LEA", "ABC"])
and if {?Selection} = "Group" then {ainvdet.product_group} = {?Group}
else if {?Selection} = "Family" then {stock.price_family} = {?Family}

 

The problem with your version is lack of brackets, I think. You should have put brackets round each of the big clauses either side of the OR. But you don't need to repeat all the conditions hence what I have put above.