Forum Discussion
Access and Excel wizard query blank beside headers
- Look again? The VALUES for FirstName in one of them are in the LastName field in the other, and vice versa.
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.
I did find "SQL View" not sure if this is what you are looking for or not!
I did email my instructor about the assignment, and she said "Looks like you have the table and query linked properly but no formula. Assuming your table has records, that would show all. You need a formula to finish the lab"
But didn't clarify further (no mention of a formula needed in her written instructions/videos) and referred me to visit her during office hours... Lab is due Sunday, her next office hours aren't until Wednesday. I emailed her about that but she's notoriously bad about getting back to students before 3-4 days have passed. If I absolutely have to, I can just submit what I have for partial credit but I absolutely hate not knowing/learning how to complete something.
I absolutely appreciate any/all help, even if I don't manage to figure it out in the end.