Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Query vs form on date between

    Click image for larger version. 
<br /><script async src=
    Name: Capture.JPG  Views: 11  Size: 18.4 KB  ID: 13269" class="thumbnail" style="float:CONFIG" />


    Baisically I am looking to get the dates between on a form from a query.

    If I put in the <= and > on the query directing to the text boxes on the form however - I go to use the form and it is blank.

    I know I am doing something wrong that is probably very simple but I don't know why...?

    I can do a Like on name with no problems and the report fetches me all the query the name I search for but I can't get dates to work (I am guessing because they are blank?).


    The query works, I get results between the dates but that is about it.

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    eh.. I used NZ and now it sorts

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-30-2013, 12:45 AM
  2. Date and Time Query Off Of Form
    By Joopster in forum Queries
    Replies: 4
    Last Post: 02-19-2013, 08:01 PM
  3. Replies: 3
    Last Post: 08-21-2012, 03:05 PM
  4. Using form combo box in query to select date.
    By LordNecro in forum Access
    Replies: 2
    Last Post: 04-14-2012, 05:09 AM
  5. Date range query from form
    By Steve Barnes in forum Queries
    Replies: 2
    Last Post: 07-29-2010, 07:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums