Conditional Select Statement

[shexe]

Hello again,
I need to create a query/process that removes a certain population from an existing query to populate a new datasheet. For instance, if ResourceName does not contain "TBD ", those records are not needed. I dont think this can be completed with a simple IIf statement. Please correct me if I am wrong. Essentially, I only need records that contain TBD in ResourceName.



SELECT [ResourceAllocation_2010-Query].ResourceManager, [ResourceAllocation_2010-Query].ResourceName, [ResourceAllocation_2010-Query].Project, [ResourceAllocation_2010-Query].January, [ResourceAllocation_2010-Query].JanuaryPercent, [ResourceAllocation_2010-Query].February, [ResourceAllocation_2010-Query].FebruaryPercent, [ResourceAllocation_2010-Query].March, [ResourceAllocation_2010-Query].MarchPercent, [ResourceAllocation_2010-Query].April, [ResourceAllocation_2010-Query].May, [ResourceAllocation_2010-Query].MayPercent, [ResourceAllocation_2010-Query].June, [ResourceAllocation_2010-Query].JunePercent, [ResourceAllocation_2010-Query].July, [ResourceAllocation_2010-Query].JulyPercent, [ResourceAllocation_2010-Query].August, [ResourceAllocation_2010-Query].AugustPercent, [ResourceAllocation_2010-Query].September, [ResourceAllocation_2010-Query].SeptemberPercent, [ResourceAllocation_2010-Query].October, [ResourceAllocation_2010-Query].November, [ResourceAllocation_2010-Query].NovemberPercent, [ResourceAllocation_2010-Query].December, [ResourceAllocation_2010-Query].DecemberPercent
FROM [ResourceAllocation_2010-Query];

[weekend00]

Maybe I didnot get what you said.
I think a where clause can do it.

[shexe]

you are right but I am having trouble with the WHERE clause. How would I write that if all I want is the record if the first 3 letters of ResourceName = TBD? This is what I tried but it certainly isnt working.

WHERE ([ResourceAllocation_2010-Query].ResourceName,3)="TBD");

[weekend00]

WHERE ([ResourceAllocation_2010-Query].ResourceName,3) like "TBD*");

[shexe]

WHERE ([ResourceAllocation_2010-Query].ResourceName) like "TBD*";

Thanks Again!!!