Forum Discussion
GennyK
Mar 10, 2023Copper Contributor
Access and Excel wizard query blank beside headers
I imported an excel datasheet (Lastname, firstname, Healthins, Retirement, TotalBenefits) into Access and created a relationship with an Access database (Lastname, Firstname, Hiredate, job title, sal...
- Mar 11, 2023Look again? The VALUES for FirstName in one of them are in the LastName field in the other, and vice versa.
George_Hepworth
Mar 11, 2023Silver Contributor
Look again? The VALUES for FirstName in one of them are in the LastName field in the other, and vice versa.
GennyK
Mar 11, 2023Copper Contributor
OHHHHHHH!!!!!
It's because she had us copy and paste the names from access where she had us add first names first into excel, where she had us use last names first. Omg. This entire semester we've not been given us a single assignment where following the instructions to an exact T has worked successfully.
Ever considered teaching classes? Please replace my professor, I'm been agonizing over "what missing formula?" for nearly a week.
The new query did work, thank you so sooooo much.
- George_HepworthMar 11, 2023Silver ContributorThank you for the kind words. I've been retired for several years. Posting in forums like this is as close to teaching as I get these days.
Congratulations on solving the mystery. Continued success with the class.