Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

IIf syntax problem.

What is wrong with:

=IIf([txtReadyQty]>0,DSum("[ShipQty]","tblShipmentDetails","[ReadyID] = " & [Forms]![frmPlanted][subfrmReady].Form![txtReadyID]),0)

--Steve
0
SteveL13
Asked:
SteveL13
1 Solution
 
PatHartmanCommented:
[Forms]![frmPlanted] !  [subfrmReady].Form![txtReadyID]
You were missing a bang.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now