Search results

  1. C

    Horrible Scientific Notation is ruining a perfectly good table

    Thanks for the help in advance, I have linked an excel table in Access. The excel table has a phone number field which is a number field in both Excel and Access. All of the numbers returned except for numbers with an extension. Those numbers returned in scientific notation. How do I get...
  2. C

    How do I avoid the union query sucking up the individuality of my tables

    Oh help, I just need one piece and my database would be perfect...well almost. I created a union query with the following syntax: SELECT [Parent Company Name], [IOU], [Count], [SumOfCount] FROM [Utilparentcount] UNION ALL SELECT [Parent Company Name], [NonIOU], [Count], [SumOfCount] FROM...
Top Bottom