DSum Like Critiria

[Dormie]

Hi,

I've got a code that works fine.

=DSum("[amount]","[qtExpense2015]","[description] = 'Walmart'")

I was looking for a slight update for something that didn't need to have the exact word but contain the word someplace in the field.

Something along these lines..... this obviously doesn't work.
=DSum("[amount]","[qtExpense2015]","[description] = Like '*Gas*'")

This probably isn't the way to handle it but I was hoping to do a couple fields like this and was wondering if I could avoid the quiery.

Thank you.

[Dormie]

Sorry, I should have put this in the Forms area. If anyone can move it that would be great.

[orange]

Try this
Something along these lines..... this obviously doesn't work.

=DSum("[amount]","[qtExpense2015]","[description]  Like '*Gas*'")

I did a test with one of my tables
Course with the following data:

CId	Coursename
1	Spanish
2	English
3	Chemistry
4	Physics
5	Latin
6	Biology
7	Botany
8	History
9	Political Science
10	Astronomy
11	French
12	Algebra
13	Geometry

?dcount("*","Course","CourseName like '*ry'")
3

[Dormie]

Thank you Orange.

The = in the criteria was what I had wrong! Got it working perfect now!!! I think......

[Dormie]

One more question.

How do I write that to include two criteria from the same field?

=DSum("amount","qtExpense","[description] like '*Gas*'")+DSum("amount","qtExpense","[description] like '*hess*'")
This works but there must be a simpler way.

Can I write something simpler then that?

=DSum("amount","qtExpense","[description] like '*Gas*' Or '*hess*'")

I'm looking for it to include both criteria but not require both to be in there.

Thank you.

[orange]

Try:
=DSum("amount","qtExpense","[description] like '*Gas*' Or [description] like '*hess*'")

[Dormie]

Awesome worked. I swear I tried that..... but got it working now. Thank you!