Access 2000 - How to exclude empty fields from report

[tinggg]

Hi

I have one column 'Workshop Group' and a second column 'Artists'. When I create a report and Group it under 'Workshop Group' I get a lot of empty fields where Artists did not reply to that question. Is there any way to exclude entries?

Thanks

 

[dhookom]

Way to vague of a question to provide anything other than a WAG. Can you share information about your report's record source and tell us what you mean by "Group it under"?

Do you realize you can apply a filter/criteria to a report in many different ways?

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]

 

[tinggg]

Ok - i have a table with two columns:
Column 1: Workshop Group (Group A, Group B, Group C etc)
Column 2: Discussion Topic (Artist, Singer, Comedian etc)

I want to create a report that tell me what each Workshop Group said on each topic. However no all worhsop group disucced all topics.

What I have done so far...
Go to Reports
Select 'Create Report by using wizard'
Selected Workshop Group and Artist (to find out what was discussed about Artists across the Workshop Groups)
The wizard asks - do you want to add any grouping levels? I select Workshop Group so that I get the answers grouped by Workshop.
My report is created but because not all Workshop Groups discussed Artists I have lots of entries that say e.g Workshop Z and have a blank entry under Artist.

My question is can I filter out Workshop Groups that did not respond on Artists?

Thanks

 

[dhookom]

Try a recordsource query like:

SELECT [Workshop Group], [Discussion Topic]
FROM [table with two columns]
WHERE [Workshop Group] Not In
 (SELECT [Workshop Group]
  FROM [table with two columns]
  WHERE [Discussion Topic]="Artists");

If this doesn't meet your needs, consider taking the time to reply with some sample records, specifications, and display results.

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]