Retrieve a Single Column

Retrieve a Single Column

You can use an Access query to retrieve a single column of data. Instead of choosing the tablename.* option on the Field line in Query Design view, choose the name of the field you want to retrieve.

To retrieve a single column:

1.   Open a table or query in Query Design view.

2.   Choose the field name you want to display in the field line.

3.   Click the Run button. Access retrieves the column you chose.

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati