manix
Registered User.
- Local time
- Today, 13:16
- Joined
- Nov 29, 2006
- Messages
- 100
Hi All,
As a relative novice this probably sounds noobish, but I am not that hot on code at the moment.
I have a table that contains data relating to quality concerns. Now one field in this table is the date the concern is closed and another is date open. I want to report the duration concerns are open for.
So basically, I need to know how to query the table to show a duration, in weeks, that the concern was OR has been open for. I can relate a date to NOW but this would only work if the field has a date and not all concerns are going to be closed when I run the query. So effectively:
If the concern has a date closed entered, then report the duration in weeks between date open and date closed.
BUT
If the date closed does not have a value entered, count the duration in weeks as date open to NOW.
If anyone can translate that into something I can use in a query then it would be most appreciated. If in VB, please explain how I get that into a usable report format.
Thanks in advance.
As a relative novice this probably sounds noobish, but I am not that hot on code at the moment.
I have a table that contains data relating to quality concerns. Now one field in this table is the date the concern is closed and another is date open. I want to report the duration concerns are open for.
So basically, I need to know how to query the table to show a duration, in weeks, that the concern was OR has been open for. I can relate a date to NOW but this would only work if the field has a date and not all concerns are going to be closed when I run the query. So effectively:
If the concern has a date closed entered, then report the duration in weeks between date open and date closed.
BUT
If the date closed does not have a value entered, count the duration in weeks as date open to NOW.
If anyone can translate that into something I can use in a query then it would be most appreciated. If in VB, please explain how I get that into a usable report format.
Thanks in advance.