Results 1 to 2 of 2
  1. #1
    AccessAlan is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2019
    Posts
    5

    Between Dates Combo Box


    Hi

    I have a form with a subform datasheet.
    I have created a query to filter the data in this datasheet. Its working for single dates and other combobox criteria.
    I cant get it to work for between dates criteria and i dont know what code i need to put into the query to make it do this

    Could anyone help please?

    Thanks
    Click image for larger version. 

Name:	Capture.JPG 
Views:	11 
Size:	73.3 KB 
ID:	40261Click image for larger version. 

Name:	Capture1.JPG 
Views:	11 
Size:	71.1 KB 
ID:	40262

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    ..."WHERE WorkDate BETWEEN Forms!frmName.[Start Date] AND Forms!frmName.[End Date]... ?
    I think you're better of constructing form driven sql in code, otherwise how do you deal with missing values that a query is expecting?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 2
    Last Post: 09-19-2017, 11:31 AM
  2. combo box with dynamic dates?
    By vicsaccess in forum Forms
    Replies: 2
    Last Post: 12-29-2015, 08:13 PM
  3. issues with filtering with combo box's and dates
    By sspreyer in forum Programming
    Replies: 5
    Last Post: 01-25-2014, 06:11 PM
  4. Replies: 8
    Last Post: 12-02-2013, 03:46 PM
  5. Filter Subform by Combo Box Dates
    By steve042 in forum Forms
    Replies: 14
    Last Post: 06-20-2013, 07:36 AM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums