Re: Retreive Only the Y results in a query

On Wed, 27 Sep 2006 15:33:01 -0700, TKM
<TKM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

My results without the Y look like this..Notice there is no N in that column
and it is either Y or nothing in the BYPASS Column it only has the Y. In the
criteria below BYPASS i put ="Y" and I receive no records. This is so simple
what am I missing.

It sounds like you're either continuing a discussion in a new thread,
or assuming we know more about your application than is visible.

Please post the SQL view of the query. What's the datatype of the
field - text, or Yes/No? If the latter, use a criterion of True or -1
rather than the text string "Y".

John W. Vinson[MVP]
.

Relevant Pages

  • Re: Running 2 reports in a form together
    ... Form where the report is run from is called "clientanddate" ... Dim strReport As String 'Name of report to open. ... here is an example that tests criteria and builds a filter string to use as a parameter in OpenReport ...
    (microsoft.public.access.forms)
  • Re: Running 2 reports in a form together
    ... Form where the report is run from is called "clientanddate" ... Dim strReport As String 'Name of report to open. ... What I need it to do is also filter in the date report using the clients name ... here is an example that tests criteria and builds a filter string to use ...
    (microsoft.public.access.forms)
  • Re: Running 2 reports in a form together
    ... here is an example that tests criteria and builds a filter string to use as a parameter in OpenReport ... Since a filter is applied on the recordset, they do not have to be on the report object ...
    (microsoft.public.access.forms)
  • Chart Row Source
    ... Dim VarItem As Variant ... Dim strLocation As String ... 'Build criteria for Date parameter range ... ' Apply the filter and switch it on ...
    (microsoft.public.access.reports)
  • Re: How to view records selected from a listbox when opening a for
    ... Dim stDocName As String ... Dim stLinkCriteria As String ... Dim Criteria As String ...
    (microsoft.public.access.formscoding)