Zane

  • Thread starter Thread starter Simple Filter Question
  • Start date Start date
S

Simple Filter Question

For some reason I can't get this to work. I have one
field in my database that has only three options to
choose from. For a report I am making all I want is one
of these options, so I am trying to filter saying in the
design view under criteria: Like "entry1". Why won't
this work. I still end up getting the other two in my
query. Any help or advice would be greatly appreciated.

Zane
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm assuming you're talking about the report's Filter property? If so,
you have to include the column name in the report's RecordSource. E.g.:

Report's
RecordSource: SELECT id, Option FROM Table
Filter: Option = "entry1"
Filter On: Yes

You see that in the RecordSource there is a column named "Option" and in
the Filter we are telling the report that we only want records where the
value of the Option column equals the word "entry1."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIgl2YechKqOuFEgEQLzGgCbBFEamqj3r2B0jq5QqJRpDgAL/1MAoMo9
XfCPIhKwkTIoh4uX7TJbL0lI
=ijpq
-----END PGP SIGNATURE-----
 
Back
Top