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.
GennyK
Mar 11, 2023Copper Contributor
I'm happy to try and provide anything, not sure what the SQL is- If you can give me an idea of what to look for I'll do my best to find it. (Prior to this class, I've never used access- so thank you for your patience).
The names, addresses, etc are all made up for the assignment.
George_Hepworth
Mar 11, 2023Silver Contributor
Maybe my eyes are failing, but it sure looks to me like the First and Last Names are swapped in those tables in your screenshot
- GennyKMar 11, 2023Copper ContributorOh, good point. Would that make a difference? I can go and reverse it.
- GennyKMar 11, 2023Copper Contributor
Reversing First/Last name order didn't change anything for me- so I'm not sure where I'm going wrong!
- George_HepworthMar 11, 2023Silver ContributorLook again? The VALUES for FirstName in one of them are in the LastName field in the other, and vice versa.