Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Wednesday, January 10, 2007 – Permalink –

View Related Fields

The whole thing


When designing a query, you'll often find the need to temporarily view fields beyond the ones you want shown in the final result.

To do so, you probably drag the relevant fields to the design grid and then delete them when you're done. However, there's an easier way to view the data that you typically want excluded in the query.

To do so:
  1. Open the query in Design view.
  2. Display the query's Properties sheet
  3. Set the Output All Fields property setting to Yes
  4. Run the query

Data from all of the underlying tables' fields will be displayed in addition to the fields you specified in the QBE grid.

To change the query so that it only displays the fields explicitly selected in the QBE grid, simply reset the Output All Fields property to No.





See all Topics

Labels:


<Doug Klippert@ 4:51 AM

Comments: Post a Comment