total days difference

[travismp]

I have 2 date fields and want a query to list the two dates then one extra column with the total days different. I thought this would show me the difference in days but no luck. Is this possible?

 DaysinLab:[DateRcvd]-[LabRcvd]

 

[travismp]

Nevermind. I found my error my query was correct. Looking at the incorrect column. Sorry all.