Need help with a SQL look up on a report 1

[Xenos132]

I have a report from my weekly time sheet, In this report I have different types of work. I would like to total based on my Type. My Type’s are S,M,B…

I am using

=Sum(Abs([Type]=)*[Hours])

When I run this, I get a pop up asking for S

If I change the Type to a number then use

=Sum(Abs([Type]=1)*[Hours])

it will work. Can I use Letters? Where is the mistake?

Thank you

 

[dhookom]

S" is a string/text value and not a field so this should work:

=Sum(Abs([Type]="S")*[Hours])

Strings/text are delimited with single or double quotes.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Xenos132]

Thankyou so much, "X" is what i was missing.