[AccessD] Sporadic "#ERROR" in Access 2007 Report Group Header

Thatis my immediate thought too.

On 21 Mar 2012 at 15:10, Heenan, Lambert wrote:

> Absent any other information, I would be wondering about Null values in the "group on" field.
> 
> Lambert 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Wednesday, March 21, 2012 2:58 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Sporadic "#ERROR" in Access 2007 Report Group Header
> 
> All, 
> 
> I ran into something that I am curious about.
> 
> I have a new report that has a header for one of the report groups.
> 
> I need to put information in the header that is derived from the field that is being used for the "group on".
> 
> This field is a code such as "A" "B" "C".  I was using a SWITCH command to change these codes into more meaningful words for the group header.  
> 
> "A" = "Gold"
> "B" = "Silver"
> "C" = "Bronze"
> 
> In my testing, I would occasionally receive an "#ERROR" message.  Not every time, just once in a while.
> 
> I then started to use an "IIF" instead of the switch command.  Again, I would occasionally receive the "#ERROR".
> 
> Sporadic problems have always scared me.
> 
> As a result, I changed my approach and used an "IIF" in the underlying query instead of using it in building the header field.  This seems to work nicely.
> 
> Nevertheless, I am still curious as to why I was receiving the sporadic errors earlier.
> 
> You feedback/insights would be most appreciated.
> 
> Thanks,
> Brad
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>