If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find data on reports
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?? |
#2
|
|||
|
|||
Find data on reports
Abdul Shakeel wrote:
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 |
#3
|
|||
|
|||
Find data on reports
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. -- Regards, "Philip Herlihy" wrote: Abdul Shakeel wrote: 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 |
#4
|
|||
|
|||
Find data on reports
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? -- Duane Hookom Microsoft Access MVP "Abdul Shakeel" wrote: 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. -- Regards, "Philip Herlihy" wrote: Abdul Shakeel wrote: 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 |
#5
|
|||
|
|||
Find data on reports
Abdul Shakeel wrote:
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. -- Regards, "Philip Herlihy" wrote: Abdul Shakeel wrote: 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 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 |
Thread Tools | |
Display Modes | |
|
|