Full Version: Days Open in Report
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
epione
Quick question that may involve a not so quick answer. Basically what i'm trying to do is create a report that says how many days an issue has been "open" in a open issues log at work. I know how to filter for open issues and the like, but what i don't know how to do, nor do i even know if it can be done, is make a colomn in a report say how many days an issue has been open. I'm assuming it would involve subtracting the created date from the current date and the converting it to a number. I have no idea how i would go about doing this. Can anyone help?
bredmell
You're correct in your assumption that you would subtract the created date from the current date but there is no need to convert to a number. Simply create an unbound text box on your report and set it's Control Source to:

=Date()-[NameOfYourDateField]

HTH

Bruce
epione
Great ... Worked like a charm.
bredmell
Happy to be of service.

Bruce

thumbup.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.