RE: [MS_AccessPros] from a new-bie, using design view for reports

Control sources can't be table/query!field
You can possibly use DLookup() to pull a value. I'm not sure why you don't use DCount().

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: ziomeks@sbcglobal.net
Date: Mon, 27 Jun 2011 23:12:15 +0000
Subject: [MS_AccessPros] from a new-bie, using design view for reports

ok, I set up a report wherein the area 'page header' i place a text box where i expect a value from a dcount to appear. The query works fine. However when I set the box to =[DbdUnqQuery]![TotalNoU] i get a ?Name error. this is probably a really stupid issue but yours truly cannot find my way out of here. help please.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/