• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MS Access - How to get only few columns from the table

ThrottleWorks

Excel Ninja
Hi,

I am using below mentioned query to get the data from table.

SELECT *
FROM [Employee Directory]
WHERE ((([Employee Directory].[Dept])='Services'))
ORDER BY [Full Name];

In the original table, I have 13 columns.
How do I get only 4-5 required column from this table.

How do I edit this query.
For example, I need columns Full Name, DOB, Dept, and DOJ how do I do this.

Can anyone please help me in this.
 

GraH - Guido

Well-Known Member
I think, replace select * with

select [Employee Directory].[Full Name],
[Employee Directory].[DOB],
[Employee Directory].[Dept],
[Employee Directory].[DOJ]

Perhaps it also needs a comma at the end. Actually do not remember that detail.

or even simply
select [Full Name],
[DOB],
[Dept],
[DOJ]
 
Last edited:
Top