Search results

Can anyone help me finish off a rather annoying problem that i've been working on? I've got a continuous subform which only usually has a few records in but can potentially contain loads (therefore requiring the scroll bar to rear it's ugly head!!) I tried out a few ideas to make it...

Yesterday i posted about a query effectively ignoring a criteria from a form if the field on the form is left blank. Someone suggested putting Is Null on the second line and that worked for one individual field but I have 6 fields that have criteria in the query. 3 are text fields so i don't...

Hi, I'm using a form to generate criteria for a query column that contains a date, the problem is that i only want a criteria generated if a field contains a value. If the field is empty I want the query to show all records I've entered the following... CRITERIA...