I have a form that has among it's fields "Date Posted" and "Date Closed". I have a calculated field called "Turn Around" with the expression "= Int ([Date Closed] - [Date Posted])". This works fine on the form and the datasheet view. I make a query for records that have a date in the "Date Closed" field to find records that have been closed. When I do this query the turn around time does not show in it's field. How do I get the calculated result to show up in a query? I am using Access 2000.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query of calculated fields
- Thread starter shall59
- Start date
If I understand your situation correctly, this should work for you...
First, you need your table with the Date Posted and Date Closed fields.
Second, the calculation should not be coded into your form; it should be in the query if you want to use it elsewhere too. You need a query that lists the fields from the table mentioned above as well as your calculation. In the visual query builder view you'll have two fields: your table.* and Turn Around: Int([Date Closed]-[Date Posted])
Hope this helps.
First, you need your table with the Date Posted and Date Closed fields.
Second, the calculation should not be coded into your form; it should be in the query if you want to use it elsewhere too. You need a query that lists the fields from the table mentioned above as well as your calculation. In the visual query builder view you'll have two fields: your table.* and Turn Around: Int([Date Closed]-[Date Posted])
Hope this helps.
- Status
Similar threads
- Locked
- Question