[AccessD] Report criteria using form

A quick fix for this, if you don't mind losing the * wildcard, you can use
the In statement...so your criteria in the query would look like this: 

In([What Department(s)? (Seperate with a comma ',')])

Then '2 West,Education' should bring up both of those departments.

Off hand, to make that process be more forgiving, I would resort to coding
the criteria.

Drew

-----Original Message-----
From: Dwylene Garcia [mailto:garciad at kentri.org]
Sent: Wednesday, March 12, 2003 3: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