schmir1
asked on
Access 2000 Query to use the larger of two numbers
I need to use the larger of two numbers in a calculation in my query.
Pseudo code would be like:
If Inventory_Qty > Order_Qty then
' Inventory_Qty - Components_needed = Surplus (below is the SQL)
([Inventory].[Quantity]-([ Forms]![BO M_Queries] ![txtBuild s]*[Qty per Asm])) AS Surplus)
else
'Order_Qty - Components_needed = Surplus
([Orders Subtable].[Quantity]-([For ms]![BOM_Q ueries]![t xtBuilds]* [Qty per Asm])) AS Surplus)
end if
It has to be SQL as it is part of a Access 2000 Query.
Pseudo code would be like:
If Inventory_Qty > Order_Qty then
' Inventory_Qty - Components_needed = Surplus (below is the SQL)
([Inventory].[Quantity]-([
else
'Order_Qty - Components_needed = Surplus
([Orders Subtable].[Quantity]-([For
end if
It has to be SQL as it is part of a Access 2000 Query.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER