Creating fields in a report with information from fields in a query

[simo7923]

I have created a report based on a query. It is all working fine apart from one small niggle. In the query i have to enter a start date and an end date. I would like these dates to also show in the report. All the other information show but i dont know where to point the fields towards to recall the information. Thanks in advance

 

[Jonathan Kok]

I don't believe you can do that. Here's a workaround:

Create a form to input the start and end dates, rather than using the query directly. Then, reference the start and end fields in your query, and on your report.

So, you have a form called "CreateReport", which has fields "StartDate" and "EndDate", and a button to open the report. In the 'Criteria' section of your query, you would reference these by making the criteria "[Forms]![CreateReport]![StartDate]" and "[Forms]![CreateReport]![EndDate]". On your report, add two text boxes, and set their sources to the same.

Should work!