Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Query on Number Of Fields Populated

Query on Number Of Fields Populated

Here is a thread that I started a while ago in the JET SQL forum.  I would like to do the same thing to a DBF.  Is it possible to combine the queries that dhookum suggested?  Thanks.

thread701-1405614: Query to Check Number Of Fields Populated


RE: Query on Number Of Fields Populated

Why do they need to be combined?

RE: Query on Number Of Fields Populated

I guess they don't need to be but how do you do a query on query results?  I have never done that before.


RE: Query on Number Of Fields Populated

Save the query as a stored proceedure(query) or as a View.

Then use it in a second query as you would a table:

Select * From MyQuery

RE: Query on Number Of Fields Populated

How does that work with a DBF?  If you do that in Access it makes a stored query with the actual database.


RE: Query on Number Of Fields Populated

Oh, yes. I'am not sure now a days. DBF - many versions.
But you can in MS ACCESS use linked tables to other dbms db tables and still store queries there to run off of those linked tables.

RE: Query on Number Of Fields Populated

A bit over my head.  I am just starting to dabble in database access.  Do you have any information in this that I could research?  Thanks.


RE: Query on Number Of Fields Populated

I think in ACCESS under File-Link Tables it will walk you through it. Once linked, just create the ACCESS queries off of the linked tables.

For more details, ask in one of the the TT ACCESS forum, or if you don't want to go that route, ask in one of the TT dBase forums.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close