I'm working on a building a basic personnel directory database for a client as a little side job and I'm having a hard time figuring out how to get a dynamic header inserted in a report that will be the letter of the alphabet for that section of the directory. If that's clear... 
I used to be pretty decent with Access but that was v2003 and I'm (trying) to use 2010 now, 5+ years after last touching the program.
I've found some sample templates on Office.com but haven't been able to reverse engineer them or get them to work in my db by dropping them in. Suggestions?
Thanks!
In reply to fastEddie:
Add a calculated column to your data source that has the first letter of the last name (for example). Then group your report by that calculated column, and put the calculated column in the group header. At least, if I understand you correctly that ought to work.
Thanks for the advice, that's similar to what I ended up doing.
I managed to get something in there and working and the report view looks fine but when I do a print preview the letter header appears above each entry - and yes I have hide duplicates set to yes. Always something....
Do you have the letter header in the Group Header section, or the Detail section? If you've got it in Detail it's going to repeat as you describe. Also, I think it will repeat like that if you set up the Group Header without setting up the grouping.
Here's what I'm getting. Left-to-Right -
Report View, Print Preview, Design View
