Microsoft Access - Parameter Query

[chicane]

I am currently writing a query in Access. I need to set up a parameter query for three fields which are called Status (text field), Authorised (date field) and Legal notices (date field).

I need to set it up so that the user can enter info into each of the fields and run the query from that but I also need to set it up so that if nothing is entered into the parameter boxes that it needs to return all results.

I have set up the first parameter query for the status field which I have entered the text below into the criteria box. This appears to work ok.

Like "*" & [status] & "*"

When I try to use something similar on the other two fields to set up the parameter query the query doesn't return any results.

[nico5038]

Did you try to change the datatype of the date fields into a string ?
Just try the Format() function.

Nic;o)

[kstevens]

make your query criteria look like this

like "*" & IIF(Forms!MyFormName.DateFieldName is null,"",Forms!MyFormName.DateFieldName ) & "*"

[chicane]

Access

thanks for the replies. I will have another shot at it using your suggestions.

Thank you

[ADezii]

Try:

SELECT tblTest.Status, tblTest.Autorised, tblTest.[Legal Notices] _
FROM tblTest _
WHERE (tblTest.Status Like "*" & [Enter Status] & "*") OR _
( tblTest.Autorised Like "*" & [Enter Authorized Date] & "*") OR _
(tblTest.[Legal Notices] Like "*" & [Enter Legal Notice Date] & "*");