Recent content by sschmidt460

  1. S

    specified field [equipment] could refer to more than one table listed in FROM clause of SQL statemen

    SELECT [Inventory Table].*, [Inventory Table].Part, [Equipment List Table].Equipment, [Equipment List Table].Name, Nz(DSum("[Quantity]","[Return Table]","[Part]='" & [Inventory Table].Part & "'"))-Nz(DSum("[Quantity]","[Requisition Table]","[Part]='" & [Inventory Table].Part &...
  2. S

    specified field [equipment] could refer to more than one table listed in FROM clause of SQL statemen

    SELECT [Inventory Table].*, [Inventory Table].Part, [Equipment List Table].Equipment, Nz(DSum("[Quantity]","[Return Table]","[Part]='" & [Forms]![Inventory Form].[Part Text] & "'"))-Nz(DSum("[Quantity]","[Requisition Table]","[Part]='" & [Forms]![Inventory Form].[Part Text] &...
Top