Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146

    Unanswered: query wildcard based on a form

    how do i write a statement in a query to use a like * statement based off a form?


    IIf([Forms]![Frm_Rpt_Dept_Error]![cmb_region]="1","like "*"")

  2. #2
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146
    i got it....


    Like IIf([Forms]![Frm_Rpt_Dept_Error]![cmb_region]="1","*",[Forms]![Frm_Rpt_Dept_Error]![cmb_region])

Posting Permissions

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