Value varies by date

[Jake94]

Is there a way to write a report when a value changes over time. For example the value = X from 1/1/08 - 1/31/08 and then it changes to Y from 2/01/08 - 2/28/08. Can a report be written from 1/1/08 - 2/28/08 where it applies the value appropriately?

 

[boblarson]

Yep, just create your generic report with the query not limited by date. Then, when you open it you provide the dates you want:

DoCmd.OpenReport "YourReportName", acViewPreview,,"[YourDateField] Between #" & Me.YourStartTextBoxNameHere & "# AND #" & Me.YourEndTextBoxNameHere & "#"

That is assuming you are using a form to select the dates and then, while leaving the form open, opening the report.

 

[boblarson]

And substituting the actual field name for this: [YourDateField] (while leaving the brackets) and replacing "YourReportName" with the actual report name and the text box names with their actual names.