Results 1 to 3 of 3
  1. #1
    SamBH is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2020
    Posts
    1

    How to query on multiple date fields

    I have a table that contains 12 outcome fields (these are drop-down lists / combo boxes) and each outcome field has a related date field e.g. 'outcome 1' paid employment, 'outcome date 1' 01/04/19; 'outcome 2' accredited training, 'outcome date 2' 30/06.19



    I'm trying to create a query that will return all outcomes achieved between two given dates i.e. I need to somehow include all 12 date columns in the query. Is this possible? Or can anyone think of a way around it?

    Thanks for your help

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    We need to see your table designs and the query you are working with.

  3. #3
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Can't you enter the data per type in 1 column. This might need some redesigning, but databasewise it makes more sense to have a lookup table with all outcome types than having multiple column sets per outcome type. This way, when you need a new outcome type, you needn't add new columns to your table, only add a new value to the lookup table.
    Click image for larger version. 

Name:	OutcomeTypes.JPG 
Views:	12 
Size:	37.1 KB 
ID:	42546

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

Similar Threads

  1. Replies: 3
    Last Post: 07-19-2019, 02:17 PM
  2. Replies: 1
    Last Post: 08-21-2017, 03:07 PM
  3. Replies: 4
    Last Post: 04-22-2015, 05:50 AM
  4. Replies: 17
    Last Post: 06-17-2014, 08:07 AM
  5. Replies: 12
    Last Post: 05-07-2012, 12:41 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