[AccessD] Report criteria using form

Didn't I send you code a while back that constructs an IN() clause from the
multiple selections in a listbox?


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Dwylene Garcia
Sent: March 12, 2003 4:11 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Report criteria using form


I have built a form to run a report that allows the user to set various
criteria using the following in the criteria line of the underlying query of
the report:  Like [Forms]![frmAttendenceReports]![txtDepartment].  This
works great if I'm looking for one particular department such as "education"
or all departments which is obtained by using "*".  I can't get it to work
if I want to run the report for two separate departments.  I have tried the
following entries in the textbox:

2 West Or Education

"2 West" Or "Education"
  

I have verified that there are records for both departments.  I have put the
criteria directly in the query and it does work... I just can't get it to
work through the form.

Any suggestions?

Dwylene Garcia

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com