Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    5

    Unanswered: Yes/No parameter query

    I have a Yes/No data type field in a query.

    I am trying to set the parameters of a report usinf the selection from a report. The combo box on the form has Yes or No as the selections to produce a report with all yes answers or all no answers.

    The query works if I type a Yes or No in the criteria of the query but I get an error that it is to complex if I try to run it from the form. I have checked the bound column etc. but can't figure out why this does not work.

    Stan

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Let us take a look at your query.

  3. #3
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    5
    Originally posted by CyberLynx
    Let us take a look at your query.
    It's okay, I figured it out, I had to format the combobox differently so that it would search for 0 or -1 but display Yes or No

    Thanks for the reply.

    Stan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •