By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,161 Members | 1,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,161 IT Pros & Developers. It's quick & easy.

filtering Reports

100+
P: 553
If i set control source of a Access Report to a table i have created, i will see all the rows from within the table.

How can i i filter data on the report - if i want to see a specific record ?

Thanks
Aug 9 '07 #1
Share this Question
Share on Google+
2 Replies


P: 80
Do you know what fields you want in the report already, like a select few? Or is it one of thoose things where the report can change?
Aug 9 '07 #2

JKing
Expert 100+
P: 1,206
This question is very broad. You'll need to go into more detail. There are several ways to filter a report. You can use the Filter/ FilterOn property of a report, open a report from a form that takes values from the form to filter the report, or have a popup form accompany the report when it opens that will filter it.

The basic idea for all of them is the same. Whether you use the filter property or not the idea is to build where criteria for the table/query behind the report.
Aug 9 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.