Recent content by CarlaKingery

Thank you for all your help! My confidence has been restored and now I'm sitting with nothing to do dangerously inventing new ideas that will simply sabotage my beautiful db. Carla :D

Whoopie!!! I think I did it!! Slightly illegal methodology but hell, it worked I think! Because Phone numbers was a Vlookup field in Excel I think it was messing up the numbers that were not Vlookup, or else they were just being stubborn anyway I copied the list and pasted them into the Excel...

Cogent1, You're absolutely right, I pretended to know Access for a temp job and just when I think I figure it out it provokes me to tears yet again. I definately have changed the field to a text field in Excel but it refuses to change over in Access. Even when I tried to relink the worksheet...

I'm close to tears with this, you guys have been wonderful and if you could just help me a little bit more . . I changed my phone number field to a text field in Excel and even deleted and relinked it. The majority of the Excel table was created by the Vlookup function in Excel but when the...

I tried the input mask but it will not allow one in a number field only a text or date field and Access will not allow me to update anything in the Design view of a linked table. Any other ideas? Thanks!! Carla

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...

Thanks so much, Perfect!! C

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...