[Solved] IF/THEN in a query criteria

[asiegelson]

Does anyone know the syntax for entering IF/THEN statements in query criteria? I am creating a query which searches my database for values based on multiple drop down list user inputs and I would like it to ignore an input if it is null.

Thanks.

[F3K Total]

Hi,
show your current query here, then you'll get help.
R

[asiegelson]

See attached.

Thanks.

This is the SQL (of the attached)

SELECT DISTINCT "1-jobs1"."JobName", "1-jobdata"."ADE-Eng1", "1-jobdata"."ADE-Eng2", "1-jobdata"."ADE-Eng3", "1-jobdata"."DataDate", "1-jobs1"."EngFirm", "1-jobdata"."DataEngContact", "1-manuf"."Manuf", "1-jobdata"."ADE-Prod", "1-Allsearchdata"."SearchData", "1-Allsearchdata"."SearchData", "1-Allsearchdata"."S-EngFirm", "1-Allsearchdata"."S-EngFirm", "1-Allsearchdata"."SearchData", "1-Allsearchdata"."StrtDate", "1-Allsearchdata"."EndDate", "1-Allsearchdata"."S-EngFirm" FROM { OJ "sys"."1-manuf" AS "1-manuf" RIGHT OUTER JOIN "sys"."1-jobdata" AS "1-jobdata" ON "1-manuf"."ManufID" = "1-jobdata"."ADE-Manuf" }, "sys"."1-jobs1" AS "1-jobs1", "sys"."1-Allsearchdata" AS "1-Allsearchdata" WHERE "1-jobdata"."JobID" = "1-jobs1"."JobNumber" AND ( "1-jobdata"."ADE-Eng1" = "1-Allsearchdata"."S-ADEENG" AND "1-jobdata"."DataDate" BETWEEN "1-Allsearchdata"."StrtDate" AND "1-Allsearchdata"."EndDate" AND "1-jobs1"."EngFirm" = 'IF [1-Allsearchdata].[S-EngFirm] IS NOT EMPTY THEN [1-Allsearchdata].[S-EngFirm]' OR "1-jobdata"."ADE-Eng2" = "1-Allsearchdata"."S-ADEENG" AND "1-jobdata"."DataDate" BETWEEN "1-Allsearchdata"."StrtDate" AND "1-Allsearchdata"."EndDate" OR "1-jobdata"."ADE-Eng3" = "1-Allsearchdata"."S-ADEENG" AND "1-jobdata"."DataDate" BETWEEN "1-Allsearchdata"."StrtDate" AND "1-Allsearchdata"."EndDate" )

[Villeroy]

http://forum.openoffice.org/en/forum/vi ... 28#p242628

[asiegelson]

I got it now. Thank you so much!!!