Some alpha/numeric data missing when I run MS Query

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Some alpha/numeric data missing when I run MS Query

FAQ

Thread Tools

Display Modes

01-28-2015, 01:00 PM

Baldeagle

Some alpha/numeric data missing when I run MS Query

Windows 8

Office 2013

Advanced Beginner

Join Date: Apr 2012

Posts: 62

Panic over!! I have discovered that if I format these fields as 'Text' instead of 'General' the Query works OK.

maybe this comment will help someone else!

Tags

alpha/numeric, missing data, ms query

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1	bobznkazoo	Excel	2	03-27-2014 11:14 AM
first character NOT Alpha numeric or Tilde (~) delete.	ksridh	Word VBA	5	03-17-2014 12:45 AM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel?	mag	Excel	0	10-18-2012 11:15 AM
How to do an alpha numeric Sort By?	Opul3nce	Excel	1	10-15-2012 11:11 PM
[How To] Generate Alpha Numeric Values in Excel 2010	stnicholas81	Excel	1	07-25-2011 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:47 AM.