Recent content by Raimond

Thank you very much

I need to calulate the number of days between received and approved. This is returning an error DateDiff ("d", main![date approved], main![date received]) Thanks in advance

Thanks for the quick response. That worked to return a value, however, it does not follow my date criteria.. It returned the total amount of "bus pass" for the entire table. I need to be able to select a date range. I am using access 2003 and do not see DSUM in my referance book.

I am having trouble with this clause Help Please.....:cool: Here is what I have that is not working. =Select sum ([amount of SS] From main Where [type of SS] = "Bus Pass") Thanks in advance