Windows XP MS Query omitting spaces in text fields

Joined
Jun 20, 2008
Messages
13
Reaction score
1
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?
 
Joined
Jun 20, 2008
Messages
13
Reaction score
1
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top