Recent content by dandud

Perfect! Simple, but (or thus) brilliant :cool: Thank you both. In fact I want the results if the box is empty, anyway the Nz function seems super useful, and new to me, so thanks for the hint!

Hi! it means that I have these 3 records with the following First_names in Table_1 (example only): 1) Roger 2) Roger and Mary 3) Farog In my Form_1 I type 'Rog' in First_name, then run the Query with the LIKE condition and Query returns no results, whereas it should give all three. So the...

Hello Access Experts, as a new member to this forum please allow me to post a simple yet a bit problematic case. I have a query that uses a couple of fields from a form in order to find potential duplicates inside an underlying table. How to properly write an sql Where condition inside a...