Enter Report Information

depawl

Registered User.
Local time
Today, 11:18
Joined
May 19, 2007
Messages
144
How would one enter general information for a specific report? For example I have a report that summarizes client activity for a certain time period. In the heading of the report I have 2 fields that need to be populated (for example: "date report submitted", and "date reviewed by bigwigs"). This is not data that would normally be entered anyplace else, although I guess it could be created as a separate form where this data would be entered. Ideally, when I run this report, I would like to be prompted for these 2 values.
Thanks.
 
Put this in a textbox:

=[Enter date reviewed by the bigwig]
 
Where do I put the textbox? I can't put in on the report, can I?
And this data is not from the record source of the report, so I would have to use
DLookup, wouldn't I?
 
Place a blank text box onto the report where you would like this text to be.

The blank text box should say Unbound.

Place the cursor in the text box, type the words you would like to use as a prompt. This must be enclosed in square brackets.

When you open the report, there will be a prompt to enter the text you want.

You may enter as many prompt text boxes as you wish. You will be prompted for the required text input one at a time.

When the report opens or prints, voila, theres the text you entered. No special queries or lookups required.
 

Users who are viewing this thread

Back
Top Bottom