<div>
Perfect! &nbsp;Thanks! &nbsp;I didn't need the ending &quot;as YourColumnNameHere&quot;
</div>


Perfect!  Thanks!  I didn't need the ending "as YourColumnNameHere"

<div>
thanks zx10r. &nbsp;I just accepted jimhorn. &nbsp;That worked better since it was for a text field.
</div>


thanks zx10r.  I just accepted jimhorn.  That worked better since it was for a text field.

<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
In my query I need to write an IF statement. &nbsp;Basically, in a new calculated field I need to do the following:<br />
<br />
IF [Status]=&quot;V&quot; then &quot;-&quot; else Null<br />
<br />
How do I write this correctly in Query expression.
</div>
</div>


In my query I need to write an IF statement.  Basically, in a new calculated field I need to do the following:

IF [Status]="V" then "-" else Null

How do I write this correctly in Query expression.

MS ACCESS Query, IF Statement in Calculated Field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Regular Expressions

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.