C
Carlos
Hello
i have 3 tables
T1
DATA (datetime PK) all days of the year
T2
Emp (text PK)
Cost_1 (number) all days except holydays
Cost_2 (number) holiday days
T3
Date_holidays (datetime ) holiday dates
the calculate field it makes, if date T1 not equal holiday T3 return
T2.Cost_1 if equal T2.Cost_2.
But if have 10 dates in holydays table the query return back 10 times same
DATA
all with same result in calculated field, what i missing i want only 1 DATA
i try this query,
SELECT T1.DATA, IIf(T1.DATA<>T3.Date_holidays,T2.Cost_1,T2.Cost_2) AS
Payment, T2.Emp
FROM T1, T2, T3
WHERE Emp='Joe'
Thank's
i have 3 tables
T1
DATA (datetime PK) all days of the year
T2
Emp (text PK)
Cost_1 (number) all days except holydays
Cost_2 (number) holiday days
T3
Date_holidays (datetime ) holiday dates
the calculate field it makes, if date T1 not equal holiday T3 return
T2.Cost_1 if equal T2.Cost_2.
But if have 10 dates in holydays table the query return back 10 times same
DATA
all with same result in calculated field, what i missing i want only 1 DATA
i try this query,
SELECT T1.DATA, IIf(T1.DATA<>T3.Date_holidays,T2.Cost_1,T2.Cost_2) AS
Payment, T2.Emp
FROM T1, T2, T3
WHERE Emp='Joe'
Thank's