Form Info to Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I saved and opened as a report. In it I have a column
listing groups shown as letters, ie A, B, C...Once I hit the end of the
alphabet I go to AA, BB, CC...I have it so the form shows A-Z first and then
continues with AA, BB, CC...

My problem is when I open the report it shows A, AA, B, BB, C, CC...How can
I keep it in the correct sequnce on the report as it is on the form?

Thanks,
Kristin
 
Try something like this, (assuming a field named "Code"):
ORDER BY IIf(Len(
Code: 
)=1, " " & [Code], [Code])
 
Back
Top