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

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