Count Number of Days between two fields?

[Randomblink]

I have never had to do this, and so I am stumped...

I have two fields...
Field One:: Day the request was called in
Field Two:: Day the request was satisfied

How do I add a field on my report that will calculate the days between those two? I don't care about workdays versus weekend... But if you have an answer that gives both that would be great too...

I have tried a few options from the HELP FILES in Access, but they are mainly showing me worksheet solutions... ugh!

Thanks in advance...!!!

 

[Randomblink]

iif([FieldOne]=[FieldTwo], 1, [FieldTwo]-[FieldOne])

Got it... I shoulda looked around first... Sorry all...

 

[Mile-O]

If you don't care about weekends and holidays then all you need is the DateDiff() function.