DaniBoy
Registered User.
- Local time
- Today, 01:47
- Joined
- Nov 18, 2001
- Messages
- 174
Hello,
I have a query where my expression is "DateResponse - DateRec" this gives me how many days it took for someting to get done. Now I could easyly make three more queries with to get dif criterias for this field. But I want to be able to find the total of records from 0 or 1 day, and the total of records >1 and the null values on my report from reading the expression. I tried dsum,dcount,sum,count, and tried sumif and countif like in excel but it does not work!!!!! Im doing this on my report where i put a textbox unbound and put the formula in it.. Please hel me to do this.
DannyBoy
[This message has been edited by DaniBoy (edited 01-26-2002).]
I have a query where my expression is "DateResponse - DateRec" this gives me how many days it took for someting to get done. Now I could easyly make three more queries with to get dif criterias for this field. But I want to be able to find the total of records from 0 or 1 day, and the total of records >1 and the null values on my report from reading the expression. I tried dsum,dcount,sum,count, and tried sumif and countif like in excel but it does not work!!!!! Im doing this on my report where i put a textbox unbound and put the formula in it.. Please hel me to do this.
DannyBoy
[This message has been edited by DaniBoy (edited 01-26-2002).]
