Database and Report with Project Information

[blkscrpn5]

Hi,

I am working on an Access database template for Lab Equipment planning projects. I have already setup the table, forms and queries for the DB and am working on the reports. The bulk of the reports are finished and when I am looking at the Report Headers, I realized that I want to have them populate with project related information(Project Number, Client Name, Address,etc). If i were to set this information up as a table, it would only be a single record.

Am I thinking in the right direction or is there a different/better method for doing this? If i am headed in the right direction how to this project information table to all values within a project?



Any help is greatly appreciated.

Thanks,

[Micron]

If you have that information on the report or underlying query it's as simple as having a calculated textbox in the header and hide the controls it would reference - assuming they're not fields in the detail section. If that were the case, you'd hide all rows that contained a project number. You concatenate the fields (controls) with desired text.

= "Project No. " & txtProjNo & " For " & txtCompanyName

[blkscrpn5]

The information is nowhere in the database at this time. It is information that i might add almost like it was part of the summary for the file.

[Micron]

Well that's puzzling. You have tables, forms, queries and the bulk of the reports done yet the data you'd need is nowhere to be found in the db. I must not have understood the
original question.

[blkscrpn5]

I created my database for use on architectural/engineering projects. The database is going to be a template for future design projects with different clients (GSK,BMS,etc) at different locations. The reports coming from the database will be for separate departments. But information within the header will be able to identify which project it will be for. I want to avoid going to each report and updating each header manually.

[Micron]

If that was supposed to help me help you, it doesn't add anything to my ability to do so. If the info you want to show in dynamic report header is in the db, I showed you how it could be done. If the info is not in the db as you have indicated then I see no hope for what I think you're after.