Create report w/specific data

[KatieK]

I need to create a report that prints out only those records that have a field marked. How do I do this? Do I have to create a query?

 

[RichO]

When you refer to a field as "marked" do you mean not blank?

Try a query with Is Not Null as the criteria for the field you are referring to.

 

[KatieK]

When you refer to a field as "marked" do you mean not blank?

Try a query with Is Not Null as the criteria for the field you are referring to.

Thank you, I created a query for Balance Due and for criteria, I used >0. This seems to pull up the ones with balances due. Thanks again.

 

[KatieK]

Thank you, I created a query for Balance Due and for criteria, I used >0. This seems to pull up the ones with balances due. Thanks again.

When I run a report, do all my queries run also? I need to create a report sorted by each Company and all corresponding info. Each company needs to go on it's own page. How do I make this clear in my report?

 

[RichO]

It all depends on where the report gets its data from. A report can only get data from one query, however one query can get data from multiple tables.

Not knowing how your report is formatted, it's hard to give an answer regarding sorting by company.

If your query already returns all the necessary records and all you need to do it sort by company, you can either make a new report based on your existing query (the wizard can help) or go into the Sorting & Grouping section of your existing report and add a grouping by company.

 

[KatieK]

It all depends on where the report gets its data from. A report can only get data from one query, however one query can get data from multiple tables.

Not knowing how your report is formatted, it's hard to give an answer regarding sorting by company.

If your query already returns all the necessary records and all you need to do it sort by company, you can either make a new report based on your existing query (the wizard can help) or go into the Sorting & Grouping section of your existing report and add a grouping by company.

Hi RichO, thank you for your help. I have attached my db. The report returns all necessary info I want. Now on the report, I need to Group by each Company and have each Company, with their data put on a seperate page. Is there a code to write for OnOpen or OnActivate?

Step by step this project is becoming clearer! Small steps.

 

[RichO]

What you want to do is a very simple report design.

Open your report in design mode and go into the Sorting & Grouping box. Select Theater Company which should be the first field (it's probably already highlighted), then change Group Header to Yes.

Close the box and you'll see that there is a new header on the report. Click on the Theater Company text box, hold down the mouse button and "drag" the box into the new header.

Click anywhere in the Group Header, outside the text box. Then in the properties box, Format tab, set the Force New Page property to Before Section.

I believe this should give you what you are looking for.