Printing a date range in Report

[Tumby]

I have a report which includes 2 columns of dates and I am trying to View and then Print a Report showing just a range of dates from this field.

I have table which includes the 2 columns - 1....ExpiryDate
2...ReferBackDate
The ReferBackDate is a calculation of ...ExpiryDate-180
However I could not see how to make this calculation in the table, so as there is a form for this table I did the calculation in the form, thinking that it would update the table- but it didn't.

When it came to running a report I put the calculation in the ReferBackDate field in the report so that the report would include these dates.

However I need to run a report based on a date range from this report.

I also have a query based on the table, in which I thought I could put the 'Between.....' criteria, but obviously as there are no dates in the table for this field- it is useless.

Can anyone PLEASE help?

 

[Preyzar]

I think the easiest way for you to solve this report problem is to have the report run from a query rather than directly from the tables. With the query you can set parameters in the date field criteria line such as:

BETWEEN [Start date?] AND [End date?]. You'll then be able to run the report for any range of dates available within your table without having to write a new query each time.

If you really want to have the ReferBackDate in the table, I would suggest creating an Update Query that updates to your formula with the criteria as Is Null.

 

[Tumby]

Thanks for that but the query does not include the calculation for the field I need to select dates

 

[Tumby]

Thank You very much!

I have run an update query (as you suggested) to update the table so I can now run the report selecting a range of ReferBackDate dates.

Thanks again!

 

[Preyzar]

Thanks for that but the query does not include the calculation for the field I need to select dates

You can include the calculation as one of the fields in the query (ReferBackDate: [ExpiryDate]-180) and set the criteria on that field - just insert the field into the existing query you are running under the report.