Need help with Counts after using ELookUp

J

Jeff

I am still stuck. I have an ELookUp statement to find out total changes in
populations. I have started with one field at the moment:

PriorHousing: ELookup("Housing","Acuity","([czn_fk] = """ & [czn_fk] & """)
AND ([AcDate] > " & Format([AcDate],"\#mm\/dd\/yyyy hh\:nn\:ss\#") &
")","[AcDate] DESC")

I tried different versions of DCount, but that just
produces a long list of title and zeros. I have attempted a few varieties of
Iff statements, without success.

All I would like for a final report is something like the following:
Total changes in Population
0 1 3 5
Housing (Totcount#) (Totcount#) (Totcount#) (Totcount#) based on the
PriorHousing results

then next field with total change counts.

I will continue to try different things, though tomorrow I have a another
project to finish.

Thanks for your help.
 
Top