criteria with query (1 Viewer)

[Bladerunner]

Can I place a criteria in a calculated field? [SellingWgt]*[SellingPrice] is ok but only
if [SellingUnits] = "lbs" or [tblSellingUnits].[SellingUnitsID] = 1

Just have a problem finding it in the tutorials

Blade

 

[pbaldy]

I don't use calculated fields, but I would assume the query would (or could) include either of those fields, and the criteria would be on them.

 

[Bladerunner]

I don't use calculated fields, but I would assume the query would (or could) include either of those fields, and the criteria would be on them.

OK,,,thanks

Blade

 

[smig]

Yes you can
Use iif()
You need to set what will it get in other cases, or it will be null

 

[Bladerunner]

Yes, sir: it is working fine with IIF statement in the top row.

Total Price: IIf([SellingUnits]="lbs",[SellingWgt]*[SellingPrice],[SellingPrice]*1)


Thanks pbaldy

Blade

 

[pbaldy]

I think I misunderstood what you were after, but glad you got it sorted.

 

[smig]

Yes, sir: it is working fine with IIF statement in the top row.

Total Price: IIf([SellingUnits]="lbs",[SellingWgt]*[SellingPrice],[SellingPrice]*1)


Thanks pbaldy

Blade

You can use as asked in your first post:
Total Price: IIf([SellingUnits]="lbs" or [tblSellingUnits].[SellingUnitsID] = 1,[SellingWgt]*[SellingPrice], [SellingPrice])

 

[Bladerunner]

Thanks to both of you.. really

Blade