Where to store misc. data?

[srmousse]

I have a handful of misc. data that is unique an really doesn't fit anywhere... I need it to be easily updateable, as it will and needs to change from time to time, What should I do with it?

Some of the data is a "Common Footer" that prints on ALL reports and DOES change periodically. I decided to create a common footer table with a single value and can access it from all of my reports... it works great!

However, I now have a bunch of other misc. data that I need to store, like the "Working Year" (I am going to use the field to dictate which year of info to pull the data from) "Common Header", etc. Additionally, I am considering storing formatting data such as font size (still considering this).

So with all this explained, to sum it all up, what is the best method for handling all of this misc. data? I didn't think creating a separate table for each piece was the best idea.

Thanks for your suggestions!

 

[ScottGem]

The way I handle this is with a single record parameters table. I add a field to this table for each item I want to store. You can then use a DLookup to retrieve the value. An alternative (where altering a table may be difficult) is to setup the table like so:

tblParameters
ParameterID (PK Autonumber)
ParameterType
ParameterValue

You would still use a DLookup to retrieve but you would have to use the Criteria clause to identify the ParameterType.