Access Date Report

[pfsman]

I need to create a report to find out what computers are due for maintenance. I have a field on the asset table called next scheduled maintenance date. I need to have the report ask the date range. Computers that are due between 8/1/08 - 8/31/08.

 

[JBinQLD]

Create a small form with a startdate and enddate controls. Set these to be formated as date.

If you want you could default these to be the start and end of current month and add buttons for next / previous months, etc.

Have a button that opens your report and hides the form.

docmd.openreport, "MyReport",acviewpreview
docmd.openform, "MyForm",,,,,achidden

In the report, create a query that displays the data you want and set the criteria of the DueDate to

BETWEEN forms!MyForm!StartDate AND forms!MyForm!EndDate

JB

 

[pfsman]

I have a form that has subforms. I need what is entered into the box automatically be placed into the table. Example:

I have a fill box that automatically fills in with the current price. The current price is a formula that reads, Purchase price - total depreciation.

The problem is that what amount is placed in this box does not appear in the table for this field.

 

[dhookom]

Please post this to another forum such as the Access Forms. This is a forum for Reports. You should also start new threads with new questions.

Duane
Hook'D on Access
MS Access MVP