Custom Report Printing

[robocopfl]

Hi I’m just learning Access 2003, so I hope this isn’t a dumb question. Is it possible , in a printed report, to “hide” or not print certain field(s) in selected records? Example: In a query, I’m doing a 2-level sort---1st sort on Last Name; 2nd sort on “Priority”. In the printed report using that query I’d like the Last Name & Priority 1 to be printed as the first record on the first line of the report. Can I get the subsequent priorities field(s) to print in ascending order (my 2nd sort in a query) WITHOUT repeating the Last Name field again for priorities 2 thru x ? I’ve tried creating some criteria expressions with absolutely no luck---not even close. Would what I want to do be anything like having Access change the value in the selected fields to null---or am I really lost in the forest? Thanks very much for any help or advice anyone would care to offer me.

[kimmer]

yep... go to the Properties for the LastName textbox and set 'Hide Duplicates' to Yes.

[robocopfl]

Kimmer: HOT DIGGITY DAMN ! Exactly what I was looking for. Works like a champ. THANKS A BUNCH.

[kimmer]

Yippee! You're welcome.