Patti, It's not difficult to create a view, temporary table, or report from a properly-normalized "narrow" table that puts the data into the wide format that your correspondents require. People here will help you get going, and you'll have a system that is much more efficient to maintain when things change, down the road, as they always do.
Bill On Tue, Jun 7, 2011 at 2:22 PM, Patti Jakusz <[email protected]> wrote: > thought about doing the "narrow" table as you suggested (kind of a cross > between your two methods), but I will have to build a "wide" table anyway, > for sending data to other health depts. I was hoping to only have the wide > one - but maybe it will be easier to have it both ways. >
