Creating Access Reports - Inserting value from Query

[write2slappy]

Hi

I have never used Access reports before however I now need to. I have linked an Access db to SQL Server. I have created a query which doesnt a count of data is my database and runs fine when calling directly in queries.

I am now building an Access report. How do I go about getting the value returned from this query (there is only one value as it is a count query) onto the form.

Does anyone have any good tutorials to walk me through Access Report features. It looks powerful but I have no idea where to start, apart form the basic of the layout which I have done.

Kind Regards

Andrew

 

[write2slappy]

I have also heard that it is impossible to include the results of multiple queries in a report

Is this true? If so, Is there any way to get around this. I want to create my queries as procedures and simply call these to populate the report

 

[dhookom]

If you have ever created a form then creating a report shouldn't be very difficult. There are wizards for this.

A report can have only one record source (query/table). You can get values or records from other tables/queries into your report in lots of other ways including DLookup(), code, subreports, controls with Row Source properties etc.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]