Forum Discussion
JoeCavasin
Jan 05, 2024Brass Contributor
MS Access Criteria
Afternoon all - intermediate MS Access skills here needing assistance to streamline a report built on several layered queries. Ideally some option exists to build advanced criteria - where results a...
Tom_van_Stiphout
Jan 06, 2024Iron Contributor
TotalCharges: iif(ADM_DATE>=START_DATE and ADM_DATE<=END_DATE, Total_Charges, Null)
Note: iif(ADM_DATE>=START_DATE and ADM_DATE<=END_DATE, "Include as ...", "Exclude as ...")
Note: iif(ADM_DATE>=START_DATE and ADM_DATE<=END_DATE, "Include as ...", "Exclude as ...")