Changing report header

  • Thread starter Thread starter BigBlueMan
  • Start date Start date
B

BigBlueMan

I'm pulling a report from a database that gives me data for different days
of the week, using a querie to determine which day's data to pull up.

Is there a way I can change the report header to reflect the day of the
week? I have a generic header in there now that gives you no day specific
info. I was wondering if I could make it ask me what day to put in the
header, even if I had to type it out.

Thanks!

Ed
 
Add an unbound control to your form. In the control source put
=Format([datefieldname],"dddd")

Jim
 
If I'm understanding your request correctly, this is easy, actually.

If you have a query that prompts you for a day, you can use the entry
typed in like this:

-- In a query, have a date field whose criteria is "=[Enter date
to query]" (or however your text should read - whatever is typed in
the brackets becomes your prompt text).

-- In your report header, create a text field whose ControlSource
is "=[Enter date to query]". You can set formatting, etc, just like
any other field, to your liking.

Does that make sense? Is it what you were looking for?

-- Judy
 
Back
Top