Month to Date information

On Wed, 24 Oct 2007 08:54:00 -0700, DaS wrote:

Its an XL file that's been imported into a table. There is no subform with
this, I'm not that advanced with Access yet.

You'll need to advance, then. You cannot calculate values like this in a
Table. Tables are for data storage, not for calculations or data display.

Base a Form on your table and do the calculation of month to date in a textbox
on the Form.

John W. Vinson [MVP]

Right. That's what I'm trying to do, but the calcualtion in the text box
only returns the total for October 2007. It doesn't change when I scroll to
prior months. That's what I'm trying to figure out. When the date on the
userform changes back to a prior month, how can I get the monthly outlet
revenue totals for that particular month being veiwed. Thanks again John.



"John W. Vinson" wrote:

On Wed, 24 Oct 2007 08:54:00 -0700, DaS wrote:

Its an XL file that's been imported into a table. There is no subform with
this, I'm not that advanced with Access yet.

You'll need to advance, then. You cannot calculate values like this in a
Table. Tables are for data storage, not for calculations or data display.

Base a Form on your table and do the calculation of month to date in a textbox
on the Form.

John W. Vinson [MVP]