I currently have this select * from admwhere (adm.id IN $P!{ID} or $P{ID}='ALL')[/code]adm.id IN $P!{ID} or $P{ID}='ALL' work great if I delete one of them, but with both I get an error. I need my report to allow users to enter more than one ID or enter no IDs (defaulting to all) and have them all show up