Re: Cumulative cost

The "Type Mismatch..." error message usually means one or more of the fields
you are using is of a different datatype. What are the data types of those
three fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Ctellez" <dogbit@xxxxxxxxx> wrote in message
news:147210E3-F974-4FD6-B5A8-C1B8D14C5177@xxxxxxxxxxxxxxxx
I did that and it works for one class. I need to calculate John does
classes
by month and annually for the education cost basis i.e. cumulative value.

So if John Doe has one class each month and the cost varies for each class
each month, He will appear as a new entry each month (therefore; new ID
number) I need to capture the total cost of his education year to date. I
have tried the following but it is not working:
Expr1: Sum ([Program Cost])*([WBE Program])+([Transition Program])

Error is "Type mismatch expression"

I have designed the query to require the student number be entered for his
YTD total.

Not sure what I am missing or doing wrong.

--
Ctellez


"Jeff Boyce" wrote:

Open a new query in design view.

Add the table that holds the data you described.

Add the field that holds "John Doe" and the field that holds the Amount.

Click on the button that looks like a backwards 3 (the "sigma" or
"Totals"
button).

The [FullName] field will show "GroupBy" beneath in in the grid. So will
the [Amount] field. Change it to "Sum" for the [Amount] field.

Run it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Ctellez" <dogbit@xxxxxxxxx> wrote in message
news:ED596E62-A9DA-475F-A775-EBF56458E844@xxxxxxxxxxxxxxxx
I am having trouble getting cumulative cost in an education database I
am
working on. There are two columns for the programs one column for the
cost
and the fourth column is the year to date total. HELP!! I need my
query
to
calculate the year to date by student and the program(s) + Program Cost
they
are taking for annual reporting purposes.
I have been doing the calculations in excel and the importing the data,
(not
what I really want to do) How do I Make the Programs (data) and the
cost
(data) to calculate the students YTD cost basis in a query?

Example:

John Doe Life Skills 258.00
John Doe Welding 304.30

The query needs to take the cost for both programs and combine them to
the
cumulative total.

Any Ideas?

--
Ctellez





.

Loading