Report Page Header tied to Field in a Make Table in Access 2000
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
Software/Hardware used:
Microsoft Access 2000
ASKED:
June 23, 2010 1:54 PM
UPDATED:
June 24, 2010 5:31 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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