Query on Number Of Fields Populated

[Swi]

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

Swi

 

[SBerthold]

Why do they need to be combined?

 

[Swi]

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

Swi

 

[SBerthold]

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

 

[Swi]

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

Swi

 

[SBerthold]

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.

 

[Swi]

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.

Swi

 

[SBerthold]

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.