displays queries

[lestats]

Hi,

I have a database from sharepoint which has 250 fields based on a survey. I imported the database into Access where I made 10 queries.

I want to know is there a way to display those 10 queries in one queries or in one form.

Given that some queries has result to display and others haven't yet.

Thanks,

 

[Mr Smin]

If the queries all have the same number of fields, of the same data types and in the same order then you can do a Union query.

Select T1.a, T1.b
UNION
Select T2.a, T2.b;

Alternatively, make a simple report for each query and put all of those in as sub reports in a new report. This will display all the results for query 1, then all the results for query 2 and so on.

 

[lestats]

As the queries dont have the same number of fields, I guess I must go with the report I guess. Do you have more info how to do this such as links our tutorial as I'm not very Knowledgeable on report.

 

[Mr Smin]

The MS site has a decent guide:
http://office.microsoft.com/en-gb/access-help/create-and-use-subreports-HA010209281.aspx

Short version based on Access 2007:
1 Use the Report Wizard and create a report based on your first query.
2 Then create a new blank report.
3 In Design View on the blank report, in the Design Tab, Controls section, click on "Subform/Subreport" and draw a large box on the blank report. This will bring up the subreport wizard. Choose the report that was based on your query and don't set any linking fields from parent to subreport.

Repeat steps 1 and 3.

 

[lestats]

Thank for your response. I decided to go with Tab form instead but the defaut view is datasheet and when I switch the view to single form, the tab form shows the datasheet view again. How can I fix it.