Access Query

[craig99]

Hope someone can help here!

I have a Access query set up with seven difference search parameters tied to a form.

Basically regardless of what parameters are filled on the form (blank and everything) I want the query to return results based only on the fields completed.

I've tried the 'Is Null' function but all this does is return all records and ignores the other completed parameters.

i.e if the start date and end date are the only fields completed then the query would return everything within this criteria regardless of the other fields. If only the supplier field was completed then again everything for this criteria.

[matthewy2]

im half smashed and cudnt read this proper lol.
if ur having a problem searchin for blanks try " "

ill read gain toimoz

[StephenDon24]

Not sure I totally follow but try

<>""

or

LIKE *

[OrangeJuicey]

does this help

http://www.fmsinc.com/tpapers/querie...lect%20Queries

http://office.microsoft.com/en-us/ac...666111033.aspx

There are things called criteria in hibernate for java which do the sort of functionality that your talking about. If you have 9 parameters and you provide 5 it'll search for matches using the 5 you did provide. It must be something along the lines of allowing each of the parameters to be nullable.

[craig99]

Thanks,

I'll have a good read and experiment and let your know

[SiE]

either that or get your criteria off a form and use code to build a custom sql query depending on which text boxes have been entered