Report Page Header tied to Field in a Make Table in Access 2000

Tags:
Access 2000
Access query
Access Tables
In Microsoft Access: How do I write the control in (properties) of an unbounded box created in a report header to display the a month I query (Criteria -Enter: Month) which then converts to a Make Table?  When I run the query and am asked, "Enter: Month" and I type in "May", I want May to show up in my report page header.  That is ultimately what I'm trying to accomplish.  Thanks - Pat C.

Software/Hardware used:
Microsoft Access 2000

Answer Wiki

Thanks. We'll let you know when a new response is added.

Since you only enter one month, just have the unbound box display the month of the date of the first record in the report. Or, make the unbound box bound to the date of the detail records. It will only show once in the header.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Cappythequalityguy
    Thank you very much Randym. I also just figured out I can accomplish this using the DLookUp function which I believe pulls from the first record as you indicated above. Excellent! Pat
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following