If your HCPCS Code field is a Number field (not a Text field), remove the
quote marks from around the value, i.e. generate:
([HCPCS Code] = 45378) AND ...
If is is a text field, it looks right. Mock up a query to see if there are
any results.

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>I have modified the Allen Browne search form to filter the results of a
> parameter query. The query gets its paramters from some of the fields on
[quoted text clipped - 28 lines]
>
> Thanks in Advance
Jan Baird - 27 May 2008 20:52 GMT
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.