Results 1 to 5 of 5
  1. #1
    drcotton is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2022
    Posts
    3

    I want a query to select a list of employees by month of hire date.


    I have a table of employees which includes a field named HireDate. I have a combo box with a list of months, and a command button. I want to create a query that will select all employees hired in the month selected from the combo box.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Hopefully your combo would have two columns.
    The first would be the Month number and the second the Month Name.

    So your criteria would be Forms!YourForname!YourComboName against the Month() function on your hiredate. That would give you those for this year, last year and the year before that etc etc?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    xps35's Avatar
    xps35 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    229
    Maybe also include the year in your query?

  4. #4
    drcotton is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2022
    Posts
    3
    Thanks, I think that will work.

  5. #5
    drcotton is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2022
    Posts
    3
    No, just the month name. I just received a solution. Thanks for your quick reply.

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

Similar Threads

  1. Replies: 2
    Last Post: 09-29-2019, 09:36 PM
  2. Trying to select the latest date by month
    By Villa123 in forum Queries
    Replies: 3
    Last Post: 08-01-2016, 03:56 PM
  3. Replies: 1
    Last Post: 09-06-2014, 01:08 PM
  4. Replies: 5
    Last Post: 03-01-2013, 04:20 PM
  5. Replies: 1
    Last Post: 09-24-2012, 07:09 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