Thank you for looking at my question,
I have a report in MS Access comparing inventory and consumption that pulls from one query but I would like to pull one item in the report header , the date the inventory data was captured, from another query.
The inventory date is the only item in a query called qryInventoryDate
and in the data source property for the textbox I hoped would display this value I had typed a select query
= SELECT [qryInventoryDate]![Inventory Date] from [qryInventoryDate]
but when I try to run the report it is prompting me for a parameter value for inventory date.
Can I get this data to display in the header of my report and if so how do I achieve that please?