Iif is not null in ms access

Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. I'm creating a calculated field Field3 in a query in MS Access. In this example, Field2 contains both numeric and character values. I want Field3 to contain only numeric values from Field2 and to convert all character values to Null values so that I can later perform calculations on Field3 as a numeric field.

This works except where Field2 is a character value then Field3 reads " Error" instead of being blank. But at least in the old German Access version which I have on this machine, I need to use semicolons instead of commas in the Query Design View.

How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Otherwise, if [ShipDate] equals today's date, return "Shipping today". Otherwise, return "Unshipped. If [Volts] is between 12 and 15 and [Amps] is between 0. Otherwise, return "Out of calibration. If [Average] is 90 or greater, return "A". Otherwise, if [Average] is 80 or greater, return "B".

Otherwise, if [Average] is 70 or greater, return "C". Otherwise, if [Average] is 60 or greater, return "D". Otherwise, return "F". Popular functions. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Similar threads M. Maggie Barr May 26, Microsoft Access. Replies 7 Views 2K. May 29, stumac. Question Split Form-Multiple text boxes as like filters with null entries permitted.

Replies 2 Views Oct 3, TDC Question Return value and null from query. Replies 11 Views May 12, xenou. Question Macro modification. Replies 1 Views Archived Forums.

SQL Server Migration. Sign in to vote. Saturday, October 1, PM. Monday, October 3, AM. Hi Jain, Many thanks for your helpful suggestion which worked a treat. Wednesday, October 5, PM. If your problem is alrady resolved, you do need to post them. Please remember to mark the replies as answers if they help and unmark them if they provide no help.