Results 1 to 2 of 2

Thread: Report criteria from form

  1. 02-28-2008, 09:50 AM #1
    henley12
    henley12 is offline Registered User
    Join Date
    Feb 2008
    Location
    Salem, AR
    Posts
    2

    Report criteria from form

    I have a form I am using to either select an Equipment ID or pull all records if no id is selected. My code in the query looks like the following:

    ([Forms]![frmWOCommentRpt]![cboEquipID]) Or Like "**"


    When I run this, however, it only does the Or part. If I select an equipment ID on the form, it doesn't just pull that. I'm sure this is a simple fix, but I can't see it. Any ideas?
    Reply With Quote Reply With Quote
  2. 02-29-2008, 11:57 AM #2
    GolferGuy
    GolferGuy is offline Registered User
    Join Date
    May 2006
    Posts
    407
    Like ([Forms]![frmWOCommentRpt]![cboEquipID]) + "*"

    This will put the Equipment ID in if it is there, and append the asterix (*) at the end which should not hurt anything, or put in just the Astrix if no Equipment ID is given. The plus sign (+) is used so that if Equipment ID is null, the Astrix is put in anyway. Using the ampersand (&) causes the Null to make the whole concatenation become null.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules