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
|
|||
|
|||
What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:-
Hi John
Can you help? Using the wizard if I type in values for the combo box all works fine. Using the wizard when I look up values from a table it fails, my report is blank. The only criteria I am using until I get it to work is the doctors name. Regards Barry "John Vinson" wrote in message ... On Thu, 13 May 2004 10:29:20 -0400, "Barry McConomy" wrote: Hi New user. What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:- 1) Choosing a name from a drop down list stored in a table (tbl_doctors), the table (tbl_consultations) has the doctors ID stored 2) From Date, in table (tbl_consultations) 3) To Date, in table (tbl_consultations) Can somebody advise the best way to proceed. Create an unbound Form, frmCrit. Put a Combo Box (tables don't have drop down lists, they contain DATA - see http://www.mvps.org/access/lookupfields.htm for a critique of Microsoft's 'lookup wizard' misfeature), let's call it cboDoctor on the form; also put two textboxes txtFrom and txtTo. Create a Query with criteria =Forms!frmCrit!cboDoctor on the DoctorID field; and = CDate([Forms]![frmCrit]![txtFrom]) AND DateValue([Forms]![frmCrit]![txtTo]) + 1 on the datefield. Base a Report on this query and use the toolbox command button wizard to put a button on frmCrit to open the report. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#2
|
|||
|
|||
What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:-
Hi John
Cancel my last request. I read the information at http://www.mvps.org/access/lookupfields.htm and now have a better understanding. Regards Barry "Barry McConomy" wrote in message ... Hi John Can you help? Using the wizard if I type in values for the combo box all works fine. Using the wizard when I look up values from a table it fails, my report is blank. The only criteria I am using until I get it to work is the doctors name. Regards Barry "John Vinson" wrote in message ... On Thu, 13 May 2004 10:29:20 -0400, "Barry McConomy" wrote: Hi New user. What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:- 1) Choosing a name from a drop down list stored in a table (tbl_doctors), the table (tbl_consultations) has the doctors ID stored 2) From Date, in table (tbl_consultations) 3) To Date, in table (tbl_consultations) Can somebody advise the best way to proceed. Create an unbound Form, frmCrit. Put a Combo Box (tables don't have drop down lists, they contain DATA - see http://www.mvps.org/access/lookupfields.htm for a critique of Microsoft's 'lookup wizard' misfeature), let's call it cboDoctor on the form; also put two textboxes txtFrom and txtTo. Create a Query with criteria =Forms!frmCrit!cboDoctor on the DoctorID field; and = CDate([Forms]![frmCrit]![txtFrom]) AND DateValue([Forms]![frmCrit]![txtTo]) + 1 on the datefield. Base a Report on this query and use the toolbox command button wizard to put a button on frmCrit to open the report. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|