I have an EffectiveDate field which is basically the date an employee started in a certain position. I have added a field in my query called #ofDays. In this field, I need to calculate the number of days from a certain date to the EffectiveDate that the employee was in that position. So essentially an equation like:

2/27/2006 - EffectiveDate = #ofDays

How would I go about doing this?

look up the DATEDIFF() function in the help menu.

WOW. It worked. Apparently I just didn't look hard enough to figure it out. Thank you so much!

no problem. look at the help menu often. that's how I learned. ;)