I used nbsp; but access thinks it's a different type of space<BR>then what was already entered. (I'm trying to get the space between the first and last names)<BR><BR>I'm using an Access 97 database to log calls. Originally I had a form with the standard<BR>input field like this.<BR><BR><INPUT TYPE="text" NAME="submit"><BR><BR>Recently I wanted to Query out a listing on the WebPage showing how many entries where in <BR>the databse. I also included a list by User (who submitted the entry).<BR><BR>I accomplished this with these statements.<BR><BR>SQL = "SELECT technotes.SUBMIT, Count(technotes.UserID) AS CountOfUserID FROM technotes GROUP BY technotes.SUBMIT "<BR>Set RS = Server.CreateObject("ADODB.Recordset")<BR>RS.Open SQL, Conn, adOpenStatic, adLockReadOnly, adCmdText<BR><BR><BR><BR> <tr><td><font color="white">All Users</td><BR> <td><font color="white"><%=objRS.recordcount%> ;</td></tr><BR> <BR> <%<BR> Do While Not RS.EOF<BR> Response.write "<TR><TD><font color=white>" <BR> Response.write RS("Submit") <BR> response.write "</td><td><font color=white>"<BR> response.write rs("CountOfUserID")<BR> <BR> %><BR> </td></tr><BR> <BR> <%<BR> RS.MoveNext<BR> loop<BR> %><BR> Up to this point everything worked fine. <BR><BR>I realized that the users were not always typing their names into the form the same way.<BR>I decided to have the SUBMITTED BY: box populated with session variables.<BR> When the user logs into the site I assign them a session("Fname") and session("Lname") which is <BR> generated by reading the Users Table - Fields - FirstName and LastName.<BR><BR> On the page used to submit the call to the database I have this statement instead <BR> of the INPUT statement used before.<BR><BR><INPUT TYPE="Text" NAME="submit" SIZE="30" MAXLENGTH="30" <BR><BR>VALUE="<%=session("FName")%>nbsp ;Â*<%=session("LName")%>"><BR><BR> The data is all entered into the database OK but the Query used to display the listing<BR> thinks the names are different.<BR><BR> Don Lefik and Don Lefik are different somehow.<BR><BR> Is there another character besides nbsp; that I should be using for a space. <BR>This would not have been a problem if this was not<BR> a pre-existing database with hundreds of entries already loaded.