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?

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.

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

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!:):)

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.