Query Expression Help

[derek7467]

Hey guys, im trying to build a query expression but keep getting a syntax error. Can someone spot check my query?



AUSun: (SELECT TOP 1 Dupe.Agent Utlization FROM qAgent Utilization as Dupe WHERE Dupe.NovellID = qAgent Utlization.NovellID AND Dupe.openDate = (DateAdd("d",7-(Weekday(Format(Forms!fAvayaWeeklyReport!dDate,"mm/dd/yyyy",1,1)))-6,Format(Forms!fAvayaWeeklyReport!dDate,"mm/dd/yyyy",1,1))) ORDER BY Dupe.openDate DESC, Dupe.NovellID)

Is the above written correctly?

I basically have a pool of data based on weekday, what i want to do is call a set of data per day:

Sunday: Data
Monday: Data
and so on and so on...

[June7]

Field and object names with spaces or special characters/punctuation (underscore is exception) or are reserved words must be enclosed in [].

Possible typos in spelling Utilization (missing first 'i').

Try:

AUSun: (SELECT TOP 1 Dupe.[Agent Utilization] FROM [qAgent Utilization] as Dupe WHERE Dupe.NovellID = [qAgent Utilization].NovellID AND Dupe.openDate = (DateAdd("d",7-(Weekday(Format(Forms!fAvayaWeeklyReport!dDate,"mm/dd/yyyy",1,1)))-6,Format(Forms!fAvayaWeeklyReport!dDate,"mm/dd/yyyy",1,1))) ORDER BY Dupe.openDate DESC, Dupe.NovellID)