Microsoft Access: Troubleshooting a query that selects fewer fields than expected

In this short screencast we'll look at the common reasons that Query Datasheet View selects fewer fields than expected.
We will also explain how the Table Caption property overrides the actual field name in a query.