Help with GUI Syntax and/or SQL

[hellfire45]

Hey guys. I really suck at MS Access. Can somebody please help this lost soul?

I need to filter my query with the following:



END is null
or
end is NOT null and is currentdate - 60


I'd like to know how to enter this properly into the GUI and/or SQL but if I put it in the GUI I guess Access will show my the SQL anyway.

Thanks so much!

[ranman256]

If you mean END is a field like [end date] then yes, you can , in the sql gui, say: [end] is null.
(fields are more readable in brackets)

but for date calculations , I would use
[end] is null OR [end] = datediff("d",-60,[end])

[CJ_London]

End is a reserved word - using it will cause problems at some point - suggest rename as EndDate or similar

also

[end] = datediff("d",-60,[end])

will always return false

[hellfire45]

END if the name of the column.

[ssanfu]

The snippets you posted doesn't really help.
It would help if you post the SQL of the query so we have some context.