DSUM combinning 2

[Hillbillie]

I need some help.

These 2 work.

=DSum("[Student Scholarships Received]![dollaramount] ","[Student Scholarships Received]"," [socialsecuritynumber]=[forms]![Student Scholarships Received]![SocialSecurityNumber]")


=DSum("[Student Scholarships Received]![dollaramount] ","[Student Scholarships Received]","[name of scholarship] like '*plus*'")

I would like to combine them into 1 dsum

Thanks,

Larry

 

[dhookom]

Try:
=DSum("[dollaramount]","[Student Scholarships Received]", "[socialsecuritynumber] = [forms]![Student Scholarships Received]![SocialSecurityNumber] OR [name of scholarship] like '*plus*'")


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]

 

[Hillbillie]

Thanks dhookom,

It works great. I use your examples except with the and instead of or.

DSum("[dollaramount]", "[Student Scholarships Received]", "[socialsecuritynumber] = [forms]![Student Scholarships Received]![SocialSecurityNumber] and [name of scholarship] like '*plus*'")