if statement problem

Hello all,

I know I must be doing something stupid here but it's driving me crazy.  I'm trying to create a report through an asp page querying an access database which is fine until I have tried to create some grouping - listing the group name only once on the report. 

I'm trying to use the line <% if  objrs(i) <> grouping then %> to detect if the grouping name needs to be input into the report or not however this is always returning true and the next bit of code is always being executed...

 any help is much  appreciated. 

The full code is: -

<%

dim grouping

grouping = "first"

while not objrs.eof

%>

   <TR>

<% For i = 0 to objrs.fields.count - 1%>

<% Select Case i %>

                 <% Case "0" %>

                                  <% if  objrs(i) <> grouping then %>

                                                   <TD VALIGN=TOP><B><% = objrs(i) %></B></TD>

                                                    <% grouping = objrs.fields("Location").value %>

                                                    </tr>

                                                    <tr>

                                  <% End if %>

                 <% Case "1" %>

                                  <TD VALIGN=TOP ALIGN=LEFT><% = objrs(i) %></TD>

                                  <td></td>

                 <% Case "2" %>

Thanks for the reply

the fields and field values being returned in this order: -

fields

Location,ID,Title,InsuranceValue,PurcahsePrice

Values sample

Room 9,1,happy valley,3500,3500

Room10,2,rounding the copelands,300,200

probably should of included the SQL statement I was using: -

strSQL="SELECT Asset_Register_Heritage.Location,Asset_Register_Heritage.ID, Asset_Register_Heritage.Title,Asset_Register_Heritage.Insura nce,Asset_Register_Heritage.purchaseprice FROM Asset_Register_Heritage ORDER BY Asset_Register_Heritage.Location,Asset_Register_Heritage.ID"

I have put into the code  the statement <%=grouping%> --- <%objrs(i)%> just after the case 0 to see what values are being fired out each time and the variables being stored are correct as in when I want the statement to be false I'm getting

Room 9 --- Room9

which should ignore the td line but its not...

likewise when it comes accross a new value in the table and I want this to be represented this statement does all the right things i.e.

Room 9 --- Room 10

It just doesn't seem to be working in the if statement