I have a very simple Query that is not behaving in a way I expect.
There is a table that has
tblSalary
SalaryID (PK)
Name
PayFrequency (FK)
tblStudentLoan
StudentLoanID (PK)
SalaryID (FK)
YearlySalary
StudenLoan
WeeklyThreshold
MonthlyThreshold
Repayment
And then
PayFrequency
from tblPayFrequency
with:
PayFrequencyID (PK)
PayFrequency
The relationship is one tblPayFrequency to many with a (FK) in tblSalary
In my Query I enter the following code into the Field box at the end of the query and the test is: (which works)
LoanRepay: Iff(([tblSalary].[PayFrequency]=2,"True","False") and this works, as the 2 is the ID for PayFrequencyID (PK)
However I would like to be able to have the query work on the actual word in the PayFrequency field, eg:
LoanRepay: Iff(([tblSalary].[PayFrequency]="Monthly","True","False")
Yet I cant find a way to do this.
What am I missing that is so obvious?
p.s
I'll expand True and False into complex formula, which I know works, but kept this query simple.
Regards