error in count

[humpz]

hi all,



i have trouble again with count in my drawing.
i write this in expression builder for my pattern

=sum(iif([status]="A" And [Remarks]="Drawing";1;0))

that place that colored red is troubled
access can't identify that
when i open report always display confirmation about value of Remarks?
what it mean?

sorry if my explain is not clear
thanks

[SoftwareMatters]

It probably means it can't find a field called remarks so it is asking for the value. I would check your field names.

[humpz]

thank's for your attention SoftwareMatters,,this is my form,i have already noticed what the problem is,,thats right i forget to insert remarks field
but i have another problem,,i dont know how to sum [&total] in drawing report,,can you solve this problem?

[SoftwareMatters]

In the report footer create a new field and for its Control Source type:
=sum([TotalFieldName])

Hope this helps

[humpz]

i have do that but it noticed enter parameter "total" value,,"total" is total field name,,what the problem??

[SoftwareMatters]

It's because you are trying to sum a calculated field and Access can't keep up.

To rectify this you need to do your total value in the query i.e. add a field to the recordsource behind the report that does your sum.

Then bring the new field in to the report and replace the total field you have at the moment.

Now in the report footer do your =sum([TotalFieldName]) and it should work.

[humpz]

finally my problem solved,,thank you very much software matters