Thread: Still struggling with DCount

I put the = sign in and now I ger a #error. DCount seems to have me on the ropes. I have rechecked the spelling of each field and query and everything seems fine. I mayjsut give up and not provide this info on the form. Iti is the reports, but I was hoping to have it on the forms where pople are working. Best, Scott "Beetle" wrote: I don't immediately see anything wrong with the way that is written. Are you putting this...

I don't immediately see anything wrong with the way that is written. Are you putting this directly in the Control Source of a text box on your form? If so you need to precede it with the = sign. =DCount("[AmountPledged]","[ContributorsPledgesQuery]","[Paid]=True") -- _________ Sean Bailey "scottyboyb" wrote: Greetings,...

On Sat, 7 Nov 2009 13:29:01 -0800, scottyboyb wrote: I put the = sign in and now I ger a #error. DCount seems to have me on the ropes. I have rechecked the spelling of each field and query and everything seems fine. I mayjsut give up and not provide this info on the form. Iti is the reports, but I was hoping to have it on the forms where pople are working. Post the SQL of the query. Is AmountPledged in fact in the query? If you open the query...

DCount does not work with forms, only Tables and Queries. A form's recordsource is also a table or query so you do not need it to apply to forms, you can use the underlying table or query. DCount("[A Field in Table or Query]","[Query or Table Name]","]","[AmountPledged] 0") "scottyboyb" wrote: I am still strugling with understanding DCount. I...

Scott, Copy/paste your new DCount here along where you are using it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "scottyboyb" wrote in message ... Thanks for the reply. I appreciate the explanation. I have put your solution in and I am geting a name error. I have checked all thenales and they appear correct....

What happens if you leave out the Where condition: =DCount("[AmountPledged]","[ContributorsPledgesQuery]") scottyboyb wrote: I put the = sign in and now I ger a #error. DCount seems to have me on the ropes. I have rechecked the spelling of each field and query and everything seems fine. I mayjsut give up and not provide this info on the form. Iti is the reports, but I was hoping to have it on the forms...