Find data on reports

[Abdul Shakeel]

Dear All,

Im not seen the find option in MS access reports, the option is not included
in MS access report or I missed it guide please.

My second question is that could I use Crystal reports with MS access
database if yes then how??

 

[Philip Herlihy]

Dear All,

Im not seen the find option in MS access reports, the option is not included
in MS access report or I missed it guide please.

My second question is that could I use Crystal reports with MS access
database if yes then how??

A report - at least as implemented in Access - is notionally a printable
document, and "Find" isn't a facility I'd expect (although I did have to
think about it!). I'm wondering what situation you have in mind where
you'd want to search for information in a report within Access? Is this
a terminology thing? Do you just mean how to find stuff in an Access
database?

There's a basic "Find" facility when you have, say, a table open (I've
never once used it). Most finding (or selection) of data is done using
a filter (very easy and powerful - see Help) or queries. And that's a
whole subject in itself. A report is more likely to be based on a query
than a table in anything but the simplest database - the query picks out
the data that should be reported.

No idea about Crystal Reports - had to look it up in Wikipedia myself.
I've never needed more than the (quite powerful) reporting built-in to
Access.

Phil, London

 

[Abdul Shakeel]

Dear Philip,

Thanks for your respons, but what, if I have a big database for payroll of
my company where I have a report "monthly payroll" which displays salary
records of all employees of the departments of the company & I want to find a
specific employee salary.

 

[Duane Hookom]

You can open a report with a where condition that will filter the report.
Assuming you have a combo box on a form that displays the employees,
cboEmployeeID

Dim strWhere as String
strWhere = "1=1 "
If Not IsNull(Me.cboEmployeeID) Then
strWhere = strWhere & " AND [EmployeeID] = " & Me.cboEmployeeID
End If

This assumes your combo box is bound to the EmployeeID field and it is
numeric.

You can create Crystal Reports with Access database tables but why?

 

[Philip Herlihy]

Dear Philip,

Thanks for your respons, but what, if I have a big database for payroll of
my company where I have a report "monthly payroll" which displays salary
records of all employees of the departments of the company & I want to find a
specific employee salary.

The key word for me there is "find" (a specific employee salary). If
you want to print a report for just one employee, Duane's suggestion is
an elegant approach (as ever).

If you simply want to "look up" the salary, create a form based on a
suitable query and use "filter by form" (see Help) to track down the
record you need. You can re-use an existing query or use the Query
Wizard to create one (stick to the fields which are essential for this
purpose). The create a form based on that query using the Form Wizard.
Run it, then click the Filter by Form button and type a criterion
(remember you can use wildcards in text strings) to pick out the record
you want when you click the Filter button. Very quick and easy, and you
can refine it to a custom form if and when you want to.

Phil