only create a report from a recordset if some conditions are met - see example

[thydzik]

Hi.

I have created a report from a recordset that works well. Now what I want to do is only create pages if the record meets some specific criterior in a field.

ie, say I have field called 'Colour', how would I create reports for only the records that have 'Black' as the value.

thanks

 

[Banana]

Have your report recordsource be based on a query with where criteria being the fields you want.

 

[thydzik]

Have your report recordsource be based on a query with where criteria being the fields you want.

heh, thanks. figured it out. as you can guess I am extremely new to access. but been amazed with what you can do with it so far.