As I wrote in another part of this thread:

Posting Date Period should be changed to a Date/Time field. The Format
function seems
to be able to apply date/time formatting to a text string that "looks" like a
date, but if it is a date it should be stored in a date/time field.

Be sure the exact field names, not any table field captions you
may have used, are included in the DSum expression. Naming problems are
typically the
source of the #Name error.

Also, please post some sample data (from just a few records) of the actual
values in Posting Date Period.

You have been exchanging some postings with Daryl S. I suggest that you stay
in one part of the thread (the Daryl S part would be good), as it is
difficult to know what you have tried when you questions are replies are
scattered around the thread.

Alan wrote:
Bruce, The cboCustomerNumber is a Text Field and the Posting Date is also a
text field,

any suggestions

Is the bound column of cboCustomerNumber a number field, and are Posting Date
Period and cboPostingDate date fields?
[quoted text clipped - 30 lines]

Thanks in advanced

--
Message posted via http://www.accessmonster.com