M
Marcos
I would appreciate help on how to find the total number of “Yes†entries from
a query that already extracts all the records from a table based on a
BeginDate and EndDate. I need to then pull this total into a Report.
Although the following works for just pulling the total number out of all
“Yes†records in my table, it doesn’t work when using the date range:
Field: Welcome1Attn_Yes: Sum(IIf([Welcome1_Attention]="Yes",1,0))
Thanks much,
Marcos
a query that already extracts all the records from a table based on a
BeginDate and EndDate. I need to then pull this total into a Report.
Although the following works for just pulling the total number out of all
“Yes†records in my table, it doesn’t work when using the date range:
Field: Welcome1Attn_Yes: Sum(IIf([Welcome1_Attention]="Yes",1,0))
Thanks much,
Marcos