Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    parameter rpt/qry using wildcard char (97)

    parameter rpt/qry using wildcard char
    I used the report wizard to create a report based on a parameter query. The parameter is a memo field. In the enterParameterValue box that shows up I

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: parameter rpt/qry using wildcard char (97)

    Exactly what are you entering in the parameter window that results in no records being returned?
    What is the underlying criteria for that field in the query?

    Generally, if you enter a string in the parameter window and want the query to find that partial string, place
    Like "*" & [Enter Number ] & "*"
    in the criteria row for that field. Replace Enter Number with the text you want displayed in the parameter window.
    (I've never used this in a memo field - I never search on them and am not sure that one can efficiently)

    Do not type an * in the parameter window directly. That will result in finding records that actually contain an *.

Posting Permissions

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