Showing results from multiple queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Let me start by saying that I am not sure if I am posting this in the right
forum.

I think it is a Form issue but it may be better in the Reports, Queries or
Data Access Pages forum.

I am using Access 2000 and am working with a database with multiple tables.
I am trying to check the data integrity.

At present I am concentrating on missing data i.e. null fields.

Assume I am working with the following tables:

People
Events
Companies

The key fields for these are:

People Customer ID
Events Reg_Number
Companies Company ID

I am looking for a way to show a summary of missing data from each of these
tables.

For example I want to show counts of

Reg_number from events with no Customer ID
People in People table with no Firstname
People in People table with Company ID not in Companies table
Etc, etc, etc

I can do the queries to generate these counts, but need someway to show all
the information in one view.

I think what I am really asking is what is the best way to show results from
multiple queries in one view.

I apologise if this is a little vague but as a relatively inexperienced
Access user it is difficult to formulate the question correctly.

Any help would be appreciated.
 
Alan Mitchell said:
Let me start by saying that I am not sure if I am posting this in the right
forum.

I think it is a Form issue but it may be better in the Reports, Queries or
Data Access Pages forum.

I am using Access 2000 and am working with a database with multiple tables.
I am trying to check the data integrity.

At present I am concentrating on missing data i.e. null fields.

Assume I am working with the following tables:

People
Events
Companies

The key fields for these are:

People Customer ID
Events Reg_Number
Companies Company ID

I am looking for a way to show a summary of missing data from each of these
tables.

For example I want to show counts of

Reg_number from events with no Customer ID
People in People table with no Firstname
People in People table with Company ID not in Companies table
Etc, etc, etc

I can do the queries to generate these counts, but need someway to show all
the information in one view.

I think what I am really asking is what is the best way to show results from
multiple queries in one view.

I apologise if this is a little vague but as a relatively inexperienced
Access user it is difficult to formulate the question correctly.

Any help would be appreciated.
Click to expand...

The very simple way would be to create a form with three text boxes, and to
use the Dcount function in the control source for each box e.g.

=DCount("Reg_Number","Events","[Customer ID] Is Null")
 
Back
Top