Grouping Issue

[TBOB]

I’m trying to group items in my report by systems. The problem is the field I’m using to group with stores the result of a lookup table. The report is in order by the IDNum of the lookup table (i.e.: 1-V, 10-B, 11-F, 15-A, 20-R, 21-H, 30-AL, 33-BE). What I would like it to do is sort by the system text name that is equivalent to that IDNum (i.e.: 15-A, 30-AL, 10-B, 33-BE, 11-F, 21-H, 20-R, 1-V). I’ve tried the Dlookup with no luck. Any help would be appreciated.

Thanks,

Tony

 

[dhookom]

Can't you add the lookup table to your report's record source query? This would allow you to join the IDNum fields and include the system text name in the report's fields to sort by.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]