Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trouble With Nz and IIF Is Null in Query.
SELECT Sum(IIf(IsNull([Q_Team Summary].Container),0,1) AS [Air Containers], Sum([Q_Team Summary].CartonsUnld) AS [Air Unloaded], [Q_Team Summary].Type, Sum([Q_Team Summary].CARTONS) AS SumOfCARTONS, Sum([Q_Team Summary].[CARTONS DONE]) AS [SumOfCartons Done], Sum(Abs([Delayed])) AS...- megaamp
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
i am trying to execute a query that
In each field use IIf(test,[Quarterly value],0) In field one test for "[employees that left that quarter] for a particular year" In field two test for "[total employees] that are only in quarter 4"- megaamp
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Executing a parameter query in VBA
I came across this when I was learning to use Access '97, it may still be valid. The query I was using was based on controls on the form the query was connected to. Whether the query is using the default pop-up parametric dialogs or based on controls on the form it is still a parametric query...- megaamp
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
