iff statement within a query to create a query by form

[onemred]

I'm trying to create a query by form query. I would have thought the syntax within the query would have been as follows but it's not working.

IIf([forms]![frmQBFRenewal]![Combo14]=Yes,Like "*", Is Null)




The field that I am querying is a date field. If Combo14 is set to Yes then I don't care what dates are in the field. I want all data returned including records with no dates. If Combo14 is set to NO then I only want records that have no date entry in the field I'm querying.

[recyan]

Just check if below gives some guidelines :

SELECT 
	myTable.TheID, 
	myTable.TheDate
FROM 
	myTable
WHERE 
	((1)=1) 
	And 
	(
		(
			IIf(Forms!frmQBFRenewal!Combo14="Yes",1=1,(myTable.TheDate) Is Null)
		)
	);

Thanks

[onemred]

I added a calculated field "Expr2" for the sole purpose of determining if my date field is blank or has a value. I then used my new field with the IIF statement. This is how I got it to work.

SELECT tblAccounts.ID, tblAccounts.AcctNum, tblAccounts.Company, tblAccounts.SLP, tblAccounts.[Renewal Date], tblAccounts.DateConfirmedNoRenew, IIf(IsNull([DateConfirmedNoRenew]),"blank","not blank") AS Expr2
FROM tblAccounts
WHERE (((IIf(IsNull([DateConfirmedNoRenew]),"blank","not blank")) Like IIf([Forms]![frmQBFRenewal]![Combo14]=Yes,"*blank","blank")))
ORDER BY tblAccounts.[Renewal Date];

[recyan]

Thanks for sharing the solution.

Thanks