I've got a report that lists a number of different records with field 
called [material] in each. I have a Total that I want calculated based on 
this field for each record listed on the report. The control source of the 
Total field I have set to:
=DSum("Net","SalesForecastCompareCallOff","ActMat like '*reports!
[SalesForecastCallOff].[Material]*'")
This does not return any values for the Total. It works fine when you 
use "ActMat = reports!SalesForecastCallOff.Material" or "ActMat 
like '*iron*'" etc but doesn't seem to like you using LIKE with a 
reference to a control.
Anybody know how to get around this?

Instead of

=DSum("Net","SalesForecastCompareCallOff","ActMat like '*reports!
[SalesForecastCallOff].[Material]*'")

try:

=DSum("Net","SalesForecastCompareCallOff","ActMat like '*' & reports!
[SalesForecastCallOff].[Material] & '*'")


*************************************************************************

This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   Internet  http://www.cis.co.uk   E-mail
cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

********************************************************************************

Brilliant. Thanks.


> 
Instead of

=DSum("Net","SalesForecastCompareCallOff","ActMat like '*reports!
[SalesForecastCallOff].[Material]*'")

try:

=DSum("Net","SalesForecastCompareCallOff","ActMat like '*' & reports!
[SalesForecastCallOff].[Material] & '*'")


*************************************************************************

This e-mail may contain confidential information or be privileged. It is 
intended to be read and used only by the named recipient(s). If you are 
not the intended recipient(s) please notify us immediately so that we can 
make arrangements for its return: you should not disclose the contents of 
this e-mail to any other person, or take any copies. Unless stated 
otherwise by an authorised individual, nothing contained in this e-mail is 
intended to create binding legal obligations between us and opinions 
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the 
Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R -
 for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  -
 for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-
832-8686   Internet  http://www.cis.co.uk   E-mail cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-
operative Bank p.l.c., registered in England and Wales number 990937, P.O. 
Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS 
Policyholder Services Limited as agent of the Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

***************************************************************************
*****