SQL/DLookup/Pulling the same field multiple times

Hello All,

I have the following expression: January: FormatPercent(DLookUp("[EOM]","OpsFeeDataQuery","[Audit Month]=1" And "AGENTID=[Enter AgentID]"),0)

That I can not get to work it seems the best route for this would be to go with SQL which I thought would be this:

Please Login or Register  to view this content.

But I get error syntax/missing operator error message...

My entire query thus far looks like this:

Please Login or Register  to view this content.

I need the query to have a field for each month (Jan, Feb, Mar, etc.) that pulls this info based on the parameters I have included a copy of my db also QA Database.zip