Search results

Thanks for the various replies and solutions. I will try them out and see what works best. Cheers, Dave

Hi, does anyone know of a way of embedding a live clock (either digital or analogue) into a Form? Thanks, Dave

Khawar, I would like to see your single query solution, but unfortunately security restrictions on our network won't let me open the downloaded file. Can you give an explanation of the query? Thanks, Dave

You are an absolute gem. This worked practically first time and has solved something I have wrestled with for ages. Thanks very much.

Please refer to attachment for details of my problem.

Wild card in IFF statement Thanks to the guys who replied so quickly. This is the first time I have used this sort of Forum and it is good to know there is help out there. So, I have tried this code, and it still doesn't work. IIf([Forms]![Criteria Form]![Customer Name] Is Not Null,Like "*" &...

I am using a criteria entry form as the source of parameters for a select query, and I am using IIF statements in the query so that if the user does not want to specify for that particular field, the search still works based on the other parameters specified. Therefore the statement I am using...