If your field name has spaces, you would use bracketing as well like FIRST NAME would be [FIRST NAME]

It might be outside the scope of this area, but I would like to see examples of SQL statements used in VB 2003 for SQL Mobile or CE.  Anyone recommend...

mkeast - are you sure he should drop table orders????

Might take a look at VB Express 2005. It's free!

-- This would give you a total count with one record

SELECT

count(custno) as Ordercount

FROM

Customer c

INNER JOiN Orders o ON c.custno = o.custno

-- This would give you a count by Date,...

Private Sub LastName_AfterUpdate()

Dim myString As String

myString = UCase(Mid(Me.LastName, 1, 1)) & Mid(Me.LastName, 2, Len(Me.LastName))

Me.LastName = myString

End Sub

Not sure about Word, but if it were me and I had the data in Excel, I would import it into Access then link to the SQL table, create an...