Hi,

I have been looking everywhere for an answer to my problem but non that I can find seem to be working.

I am pulling a database from a hiring software using MS query. It has a list of different items we hire out, which I have narrowed down using a parameter on the category field. I now want to narrow it further using the name, which is fine however I need it to still give all the results of the category if the parameter is left blank. All the answers I have seen for the same problem and I dont totally understand SQL so would ideally like to get the desired results using the criterea. Although any answer would be usefull!