Hi folks. I am new to this in all honesty. I have used MS Access quite a bit in the future and I am already finding this pretty easy to navigate and learn, although some basic syntax for simple formulas is causing me some issues... Can anyone help me with what the syntax if for a if statement that is just looking to see if a date field is blank.. if([Active To] = "", "Active","In-Active") I have tried Is Null etc and I can't get anything to work. lol. The [Active To] field is a Date format fyi.
Been at this a long time and still constantly refer to this section.
cooper collier 3/6/2023 11:17:52 AM
This is what you need. I just tested it in one of my databases, if it does not work in yours something else is going on so email me cooper@frobbit,com
If(IsNull([Active To]),"In-Active","Active")
JonnyGee 3/6/2023 12:14:13 PM
Works perfectly dude!! Thank you! Yeah I took a look at that but I couldn't see anything related to how it handles dates and I would have never have guessed in a million years to have the IsNull first.... Thank you again... I am getting there slowly, but it seems little silly things like that slow me down something chronic! Have a nice day!