Putting a date on a report

[Margaret]

I have a query (Query B) that gives me all the site locations that are not listed in another query (Query A). Query B is generated from a table (all site locations) and Query A(only lists sites that have information a particular date). When I run query B it asks me what date. I give a date (say 11/15/99) it will give me all the site locations with no data on that date but I want to put that date (11/15/99) on a report that listed all the sites that there is no information for that date. I'm not sure how I can do that. Any sugguestions?

 

[Lou]

You should be able to use the date field from your query and put it in the Report/Page header with a description for what it refers to.
...Lou

 

[jekirksey]

use an unbound text box to refer to the date you input by whatever is contained in brackets in the query (I assume this is how it is queried with a variable for instance if the criteria in your query is "[Input Date]" then have a text box with =[Input Date] in it.(whatever is contained in brackets should be the same as what the prompt states)