Null Records in Reports

[Guest]

I have a table with the field "desired_price_range" which holds numbers from
a drop down menu - ex: 201-250; 251-300. However, some of the records input
have left this field blank. When writing a report and grouping by price
range I receive the records with no price range at the top which is fine. Is
there a way to give the Null value a name for the report like "undecided"?
So the report would read as follows:

Undecided
150-200
201-250
etc.

 

[John Spencer]

Sure, one method is to use the format property of the control.

Format: @;"Undecided"

That will place Undecided in the control whenever the bound field is null.

 

[Guest]

Oh my gosh! Thank you! So simple - I'm so braindead! This worked
perfectly. Thank you again. (Can I keep you on my "help me!" list!! )

Colleen

 

[John Spencer]

Sure, my name is
microsoft.public.access.reports

In other words, use the newsgroups.