Search results

Her's the SQL version SELECT HeatBpam_CallLog.CallID, IIf(IsNull([Closeddate]),DateDiff("d",[RecvdDate],Now())) AS DaysOpen, HeatBpam_CallLog.CustID, HeatBpam_CallLog.CallType, HeatBpam_CallLog.SubCallType, HeatBpam_CallLog.RecvdDate, HeatBpam_CallLog.RecvdTime, HeatBpam_CallLog.CallStatus...

Hmm So, Bob, are you saying you don't know how to do it either?

How do I post it, I don't know how to save it in order for me to post it.

There are 2 fields in my queary that are named the same as in the database, that would be "closeddate" and "Recvddate" Is that what you are speaking of? DaysOpen: IIf(IsNull([Closeddate]),DateDiff("d",[RecvdDate],Now()))

lost Ok, now I'm really lost.

Brackets and "Date" Bob! Thanks for responding. Well here is the problem, (1) I can't remove the brackets, every time I do and save it, they are reinserted! (2) If I use "Now()" instead of "Date()", The days open column is blank. Thanks for your help. I'm so frustrated with this and I...

OK, here is the next problem, It shows up fine in Access when I run the query, but now when I export it to excel, I loose all the numbers from the column. Any way to make sure this exports?

Bob, Thanks for getting back to me so quick I was able to get it to work finally, but the only problem that I'm having is that, when I run the query, It will ask for the current date, I want it to just atomatically grab the current date and put the value in the box of how many days there...

dates I tried your formula, but it comes back with "its too complex". I just changed the "date closed" to my columan header which is closeddate and the date received to recvddate. Due to the headings of my columns. Any suggestions? IIf(IsNull([ClosedDate]),"Not Closed...