Sorting Blank Records

[vicky464]

I have a report that lists classes and satisfaction scores for each class. To everyone's surprise, there were a series of classes that had no name, which show up at the top of the list as one item (grouped) so in the report I renamed the whole group of blank classes with a more appropriate name, using an IIF function. I would love to have the report sort in alpha order with this class sorted among the others but it remains at the top of the list because Access still treats it as Blank and the name I assigned is not sorted. Is there a way to get it to sort with the other names? THanks!

[RuralGuy]

Use a query for your RecordSource of the Report and do the naming in the query. Then sort on that field.

[ssanfu]

..... To everyone's surprise, there were a series of classes that had no name, ........

I am wondering why are there classes with no names? This sounds like a design flaw. Or at least a validation problem. Or maybe you are getting a cartesian product from your query....

[vicky464]

Steve - the data is imported from excel spreadsheets, so I dont really have a way to validate it before it is dumped in the database; do I?

Rural - I will give it a try, my report is based on a crosstab query, which is based on a select query. I will see what I can figure out. Thanks.

[RuralGuy]

Let us know how you make out.

[ajetrumpet]

Let us know how you make out.

or as the Aussie's would put it:

Let us know how you get on...

(or is that from the UK?)

[ssanfu]

Steve - the data is imported from excel spreadsheets, so I dont really have a way to validate it before it is dumped in the database; do I?

Probably not without a lot of work (and a lot of code). Do you know how it is being imported?

What happens when the spreadsheet is imported? Is the data put in a temp table, then moved to other tables? Is the spreadsheet data (flat file) being split up to a normalized structure?

If the class name is blank, how is the class name determined for a given record?

After the spreadsheet import, could you run a few update queries to fill in the class names?
If there are a couple of fields that would determine the class name, code could be used to loop thru a recordset to update the class name.

Sorry for all the questions. Just trying to understand the process......