Query expression

[eholtman]

Good Morning. Have a quick question for the gifted.

First let me say I have inside my table
Target Install, Received Date, and Type of Circuit

In the Query, I have created a column with the following statement. Due Date: [Target Install]-30 which works great to give me 30 days from the target install. The issue is that this statment is not correct for all products.
So I need to understand how to build a formula for this in the query.

If [Type of Circuit] = "Branch Network Frame" than [Target Install]-30 or
If [Type of Circuit] = "Class I" than Received Date+7

to go in the column for the query.

Thanks

 

[KeithG]

Try this in your query.

Date Due: iif([Type Of Curcuit]="Branch Network Frame" ,[Target Install]-30 ,iif([Type Of Curcuit]="Class I",[Received Date] + 7,""))

 

[eholtman]

Thanks works great.