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

Cappythequalityguy
15 pts.
Tags:
Microsoft Access 2000
Microsoft Access queries
Microsoft 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
Asked: Last updated:
Related Questions

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.
  • 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.

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

Following

Share this item with your network: