Search results

Phew you're lifesavers! Thanks for the quick response. I just used the IIF method first because I could change the rows/columns later in the report. I'll hang onto the public function method for future reference. The sample query worked great and I hadn't used the IIF function before so it was...

I have a field with about 400 records in it containing dates. I made a query to show the number of days that have elapsed between the date in the record and the current date. e.g. If the record is April 11, the query will say 116 days have past. Then I modified it so it would show the number of...