What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:-

message from Barry McConomy on 13 May 2004

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.

Regards
Barry

Lynn Trapp replied to Barry McConomy on 13 May 2004

1. Create a form with a ComboBox (that will be used to look up the doctor's
name), and 2 textboxes for the From and To Dates.

2. Create a query that references those three controls in the criteria, and
make that query the recordsource for your report. The general syntax for
referencing that is:

=Forms!YourForm!YourControl

Barry McConomy replied to Lynn Trapp on 14 May 2004

Lynn

Thanks for the advice.

Barry

"Lynn Trapp" <ltrappNoSpam@ltcomputerdesigns.com> wrote in message
news:%236rT6VQOEHA.1392@TK2MSFTNGP09.phx.gbl...

John Vinson replied to Barry McConomy on 13 May 2004

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

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

Barry McConomy replied to John Vinson on 14 May 2004

John

Thanks for the advice

Barry

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:21b7a092b1mo2kob81i5gr70pcv90m9kse@4ax.com...
DateValue([Forms]![frmCrit]![txtTo]) + 1

Archived message: What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:- (MS Access Forms)