Trevor
03-07-2008, 05:36 PM
I have a query that I am trying to pass criteria to :
forms![E-Report]![State]
and when I try to run the query, the result is a blank table.
the query should return records that match the field[state] value on form "E-Report"
I have also tried using in the critera for my query
>=forms![E-report]![State] And <=[forms![E-Report]![State] and I get the same blank table
(below is running query w/o criteria)
the other problem I am having is since what should be returned also returns email address, in a subquery(still part of the same query though) returns duplicate address, how do I select distintct on the email address while keeping all of my other data
forms![E-Report]![State]
and when I try to run the query, the result is a blank table.
the query should return records that match the field[state] value on form "E-Report"
I have also tried using in the critera for my query
>=forms![E-report]![State] And <=[forms![E-Report]![State] and I get the same blank table
(below is running query w/o criteria)
the other problem I am having is since what should be returned also returns email address, in a subquery(still part of the same query though) returns duplicate address, how do I select distintct on the email address while keeping all of my other data