Attempting to create sum count if query

[sergi117]

Hey everyone I have two tables of data. One containing names and hire dates, the other containing pay periods. I would like to make a query which counts if the hire date is within the pay period (<= ending date) and sums the counts. However in attempting this, I get results which are far too high, naturally because these tables aren't joined together. Unfortunately there are no real columns which the two tables can be joined with. Is there any solution for this so I might be able to get a sum of the counts? Perhaps an alternative to count or something?

Table 1
Name1... Hire Date1
Name2...hire date2

Table 2


Date beg...date end
Date beg2..date end2
Etc

[alansidman]

Probably a parameter query where in the criteria for the HireDate field you will place the following

Between #1/3/2018# and #1/17/2018#

changing the dates as appropriate.

[Micron]

this might be a repeat of this post
https://www.accessforums.net/showthread.php?t=73998

It's not clear in either thread if the person factors into this problem. I doubt there is a way to relate the hire date of a person to any pay date when the person can't be related to that date. Again, it's not clear if that is the goal, but I'm thinking it's not.

[sergi117]

Fixed it actually, turns out since there were duplicate records, the sum(iif was resulting in multiple counts. A simple select distinct and then sum(iif solved my issues. I'd mark this as solved, but I'm unsure how.

[sergi117]

Found the solved selection nvm.