sobeitjedi

Hi.

I have an excel query which is linked to an SQL data base. The query is as follows ...

SELECT f.order_no, f.prty_id, b.add_1, b.add_2, b.add_3, b.add_4, b.add_5, b.post_code, b.tel_no, f.cont_name, f.cont_tel_no, f.message1, f.message2, f.cntr_ref, e.completed_dt, RIGHT(d.acp_reg_ref,7) AS 'Reg_Ref', f.ord_tot_cst, a.gross_val, e.inv_dt_amt
FROM qlfdat.dbo.acptran a, qlfdat.dbo.cmpadd b, qlfdat.dbo.hgmprty1 c, qlfdat.dbo.hpmmatch d, qlfdat.dbo.hpmohsup e, qlfdat.dbo.hpmordhd f
WHERE (a.comp_id='PHA' And a.comp_id=c.comp_id) AND (c.comp_id=d.comp_id) AND (d.comp_id=e.comp_id) AND (e.comp_id=f.comp_id) AND (b.add_id=c.add_cd) AND (c.prty_id=f.prty_id) AND (a.ref_id=f.cntr_ref) AND (d.order_no=f.order_no) AND (f.order_no=e.order_no And f.order_no>43500 And f.order_no<44070) AND (e.order_no=a.ref3) AND (a.ref3=d.tr_ref3) AND (c.acp_led_id=d.acp_led_id) AND (d.acp_led_id=f.acp_led_id) AND (f.acp_led_id=a.ledger_id) AND (a.ledger_id='PL1') AND (a.seq_id=d.ql_seq_no) AND (a.regs_ref=d.acp_reg_ref)
ORDER BY f.order_no


I'm trying to remove the >43500 And f.order_no<44070 part of the query as this is no longer needed, but when I remove it and re-run the query I get an error message in Microsoft Query saying something like 'bad syntax' or 'invalid data as int'.

Can someone help me?