Share via

Spaces between columns in Access queries

Floyd Reece 0 Reputation points
2026-02-26T00:44:28.5133333+00:00

Can you create space between columns when creating an Access query?

Microsoft 365 and Office | Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. EmilyS726 211.2K Reputation points Independent Advisor
    2026-02-26T01:26:36.52+00:00

    Hello

    Do you mean to insert a column that's got blank value?

    If so, this is how you do it in query design mode:

    For "Expr1", you can replace it with whatever header label you want to call it.

    Then just put " " after the colon mark.
    User's image

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.