Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Between' in Query (2003 (SP2))

    Silly question, as I've done this before successfully but forgotten how!

    I want to query a basic table using the 'between' in the criteria. The the 'between' references form text boxes, but results in zero records.

    I know the data is there, (and the form is open with relevant data in the text boxes) but I'm clearly doing something wrong.

    Here's what I've put into the criteria;

    Between [forms]![Form1]![txtEISfrom] And [forms]![Form1]![txtEISto]

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Between' in Query (2003 (SP2))

    It should work if you enter valid data in the text boxes. What type of field are you using the criteria for?

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Between' in Query (2003 (SP2))

    Ever felt a prat? Cause I do <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

    Came back this morning & it worked! I'd got the criteria in the text boxes wrong.

Posting Permissions

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