Expression Help

[xmeb]

I am using the following in a text box on a report which works fine but in addition to returning the total of all vehicle jump starts which it now does I also want it to return the daily total for the report date.

=Sum(IIf([Action]="Vehicle Jump Start",1,0))

 

[dhookom]

I think we need to know what you mean by "daily total for the report date". I'm not sure how we are supposed to understand this.

Duane
Hook'D on Access
MS Access MVP

 

[MacroScope]

Maybe I'm missing something here, but if each jump start is assigned a 1 and you sum the 1's, won't that also give you the total number of jump starts? Sure seems like it will. You can do a count of the domain to get an overall count, and if you need the 0's, just subtract the sum of the 1's from the domain total.

Obviously it won't display in one text box though.

 

[TheAceMan1]

How are ya xmeb . . .

Have you looked at [blue]DCount[/blue]?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]