hi everyone,
I have been asked to look at a DB from work, but i am having trouble understanding the following expression:
Conflict: IIf((Sum(IIf([Drafting Schedule]![Due Date]<=[Dafting Sch Qry]![Due Date] And [Drafting Schedule]![Due Date]>=[Dafting Sch Qry]![Start Date] And [Drafting Schedule]![Project Name]<>[Dafting Sch Qry]![Project Name] And [Drafting Schedule]!Operator=[Dafting Sch Qry]!Operator,Yes,No))<>0) And (Sum(IIf([Drafting Schedule]![Due Date]<=[Dafting Sch Qry]![Due Date] And [Drafting Schedule]![Due Date]>[Dafting Sch Qry]![Start Date] And [Drafting Schedule]!Operator=[Dafting Sch Qry]!Operator,[Drafting Schedule]![Estimated Hours],0))>8),Yes,No)
can someone help clarify?
it'd be greatly appreciated.
thanks,
Jm