<div>
Thanks. That seems like it should work, but I get this error:<br />
<br />
Run-time error '2100'<br />
<br />
The form or subform control is too large for this location.<br />
<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />--------<br />
<br />
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)<br />
&nbsp; &nbsp;Box28.Width = (([Completed (mm/dd/yyyy)] - [Request date]) / 100) * (1440 * 4)<br />
End Sub
</div>


Thanks. That seems like it should work, but I get this error:

Run-time error '2100'

The form or subform control is too large for this location.

------------------------------------------------------------------------------------

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   Box28.Width = (([Completed (mm/dd/yyyy)] - [Request date]) / 100) * (1440 * 4)
End Sub

<div>
Never mind, now it works. Thanks!
</div>


<div>
<div class="content wysiwyg-content">
In a report, in addition to the fields in my table, I've made a field that returns the days taken to finish a work request:<br />
<br />
=([Completed on]-[Request date])<br />
<br />
Now I'd like to make a graph of this data against the field [Request ID], which is already in my table, but I'm not sure how. Any ideas? Thanks. <br />

</div>
</div>


In a report, in addition to the fields in my table, I've made a field that returns the days taken to finish a work request:

=([Completed on]-[Request date])

Now I'd like to make a graph of this data against the field [Request ID], which is already in my table, but I'm not sure how. Any ideas? Thanks. 


Making a graph from a field in a report...

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.