DLookUp #Error on CrossTab Report

[Justin.ITPro]

I have a CrossTab Report that is getting the Counts of field values in a query sorted on CommunityGroup. I need to have another table's values inserted to do some calculations on these totals, so I used a DLookUp:

=DLookUp("CBudget","Contract Budget","[CommunityGroup] = " & [txtCommunityGroup])

However this gives me an #Error. Is there another way to pull in these values to get these calculations or what am I doing wrong?

 

[vbaInet]

One of the two (exactly as written, copy and paste):

=DLookUp("CBudget","[Contract Budget]","[CommunityGroup] = " & [CommunityGroup])

=DLookUp("CBudget","[Contract Budget]","[CommunityGroup] = '" & [CommunityGroup] & "'")

 

[pbaldy]

Also, you may need to bracket the table name due to the inadvisable space. I've seen it work without, but can't hurt to add them.

 

[Justin.ITPro]

Thank you... that worked well. Figured it was simple. I am kicking myself, I should have known that.