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
 
Back
Top