R
ram
I would like to add a field to the query below that calculates the number of
computers that have been ordered but not shipped.
I would like to add a field that counts the number of people where
[Order_Date] is not blank and [PC_Ship_Date] is blank to the query below
SELECT Count(Processtbl!Invitation_Sent) AS [Invitation Sent],
Count(Processtbl!Date_Computer_Ordered) AS [Computers Ordered],
Count(Processtbl!PC_Shipped) AS [Computers Shipped]
FROM Processtbl;
I would prefer not to create a seprate query. Thanks in advance for any help
computers that have been ordered but not shipped.
I would like to add a field that counts the number of people where
[Order_Date] is not blank and [PC_Ship_Date] is blank to the query below
SELECT Count(Processtbl!Invitation_Sent) AS [Invitation Sent],
Count(Processtbl!Date_Computer_Ordered) AS [Computers Ordered],
Count(Processtbl!PC_Shipped) AS [Computers Shipped]
FROM Processtbl;
I would prefer not to create a seprate query. Thanks in advance for any help