Creating a report with specific records only

[SherWat]

Hello all. First time posting to this particular forum. My knowledge of Access is limited gleaned from trial and error.

I have a table that contains cell phone numbers and who they are assigned to as well as their division and unit name. Within this table I have a column that is a text field for Print on Report - Yes or No.

I have tried to use the report wizard to create a report showing only those records that have YES within the print on report field but am having no luck.

Could someone perhaps point me to a good how to guide for doing this please.

Thank you.

 

[dhookom]

Welcome to Tek-Tips. This is a great place to ask questions and get good answers.

Your report has a Record Source which is either a table, query, or SQL statement. While in design view of your report, view the report properties and find the Record Source property on the Data tab. Click the [...] builder button to the right of the Record Source to open the record source in design view. This is a query design view. You can add any filtering you want by entering the appropriate values under the appropriate columns. View the datasheet of the record source query to confirm it is correct and then close and save the record source.

Run your report to see the results. Save the report design.

Once you have this figured out, you can create a form that allows the user to select which records to report and then click a button that opens the report.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016