When I query the database using MS Query the spaces in test fields are omitted (John Smith shows as JohnSmith). Other software doesn't have this problem. Why may MS Query be doing this?
The problem went away when I openned a new spreadsheet and redid the query though I'd still be interest in why it omitted the spaces in the first place.
