Query for multi valued field containing several dates

[mathsbeauty]

There is a
"Dates table" containing fields "Dates_ID" and "Dates" (field format: "Date/Time").
The field "Dates" from this table is added in another table "Staff List" by selecting the option "Add Existing Fields" from "Datasheet Tab" with option "Allow Multiple Values" selected. This field is named as "Dates1" in table "Staff List". It contains multiple dates in dd-mm-yyyy format. For example one of the values is "18-10-2015, 19-10-2015, 21-10,2015".
The problem is that queries of dates don't run for this field. This may be because the field format for this is "number". Also I can't change the field format to "Date/Time". On changing it to "Date/Time" the error is "You can't change a multi-valued lookup field to selected data type."
I want to run a query that will show records between two dates (say 18-10-2015 and 21-10-2015) based on the query from this multi valued field "Dates1"
Would this be possible? Any help or way around would be appreciated.
Thanks.....

 

[JHB]

Don't use Multiple Values field type, they only cause problems as you recognize.
Create a "sub" table for the dates.
And if you quire for dates in should be in US-Format, MM/DD/YYYY.

 

[arnelgp]

join you "Dates table" in your query to your Staff list table using staff list's Date1.Value field against Date_Id of "Dates Table"

 

[mathsbeauty]

join you "Dates table" in your query to your Staff list table using staff list's Date1.Value field against Date_Id of "Dates Table"

Sorry, I could not get it. If possible you may help with attached file.

 

[arnelgp]

SELECT [Dates] FROM [Staff List] Inner Join [Dates Table] On [Staff List].Dates1.Value = [Dates Table].Date_ID

 

[arnelgp]

here, take a look at "Staff List Query2"