Search results

I'm new to writing nested iff statement. Can anyone help me understand the how to write arguments to avoid syntax errors??? I'm need to write multiple iif statements with arguments that will not change/ignore a field that has a current date displayed MM/DD/YYYY but will flip fields that have...

:mad:Hello I'm new to queries! I'm having a problem writing an update query that will look at a name field ie (Dan Wilson Sr) and flip the name to a shortname ie (Wilson Sr Dan) with the criteria based to only flip the name if it contains Jr or Sr. Below is an example of a select query I was...

Thanks Craig, The query worked perfectly!!!!!!

Ok Craig...you're awesome...it worked. One more question. In order to permanetly update my table "Status" field, should I keep the <> "Active" remark for in criteria field for "status" and use the following syntax for the update Switch([Status]="J","Active",[Status]="T","Non...

Hello Craig, I apologize for reposting your typo, I actually corrected it before I attempted to use it. I tried your suggestion to see if i could display records in the status field that were Not "Active" and it worked. When I added the additional field to the select query "xstatus" with the...

Before I use a update query that will affect my table, I am first using a select query just to view the results. I am using the data from the field status and I want to display the results in my expression column named "xStatus" In the QBE grid I'm displaying columns "Status" and "xStatus". In...

Before I use a update query that will affect my table, I am first using a select query just to view the results. I am using the data from the field status and I want to display the results in my expression column named "xStatus" In the QBE grid I'm displaying columns "Status" and "xStatus". In...

Hello, I'm new to working with Access Iif statements. I'm attempting to change data values in an existing table for column named "Status." Some of the data in this column has the correct value (Active) that needed represented, while the rest is populated with either a "J" which is Active or "T"...

Thanks Jon

Nest if statement!Not sure why this query will not run Thanks Jon! Iappreciate your help! I'm new to using SQL and access.

I'm wanting to run an update query but first I want to see the results by using a select query to make sure that I'm getting the correct results. See the following query statement: SELECT ([Goodrec - All] INNER JOIN WH_ACCTCOMMON ON [Goodrec - All].ACCTNO = WH_ACCTCOMMON.ACCTNBR) INNER JOIN...