Customising headers

  • Thread starter Thread starter Greg Shickle
  • Start date Start date
G

Greg Shickle

Ok, I realise this might be an easy one, if so can you
please help out a novice Access user?

I'm trying to create a header in a report that lets the
user know which date period they've selected.

thanks very much

greg
 
Let me assume you created a query and in the criteria
field under a ActionDate you entered something like:
Between [StartDate] and [EndDate]
In your report header you could than create an unbound
textbox (this means not bound to specific data from your
table or query so the name is not the same as the data
name), make sure the textbox is large enought to
accomodate the desired text, and in the source for the
textbox enter something like:
="Between " & [StartDate] & " and " & [EndDate]
Make sure to include the " and = and [ just as shown.
Hope this helps.
Fons
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top