View Full Version : Enter Report Information


depawl
03-29-2008, 03:04 PM
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.

pbaldy
03-29-2008, 03:07 PM
Put this in a textbox:

=[Enter date reviewed by the bigwig]

depawl
03-29-2008, 07:01 PM
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?

statsman
03-29-2008, 07:15 PM
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.