Report sorting issue - need to change order

[GOVMATE]

Hello All,


I'm using MS Access 2003. I have a report that sorts alpha ascending but I want one the sort fields to be appear 1st and then ascend the remaining. For example the field that is being sorted at the second level starts with an "F" and the first level starts with an "E". I want "F" the sort first and then sort "E" and the remaining ascending. I have a attached a copy of my report design view. Any assistance would be greatly appreciated.

Thanks!

 

[vbaInet]

If you're using a query as the record source of your report, add this in there:

AliasField: IIF(Left([FieldName], 1) = "F", 1, IIF(Left([FieldName], 1) = "E", 2, 3))

Substitute [FieldName] with the name of the field and you can call AliasField anything you want except any of the field names.

Now you first of all sort by AliasField, followed by the field.

 

[GOVMATE]

The record source is a table. Can you help?

 

[vbaInet]

Change it to a query. Remember a query can pull the fields from a table. Use the wizard to create the query and once you've done that set the Record Source to the query.

 

[GOVMATE]

Hi VbaInet!

I really appreciate your help. I am going to try what you suggested.

Thanks again!

 

[vbaInet]

Let us know how you get on.