basic expressions

E

Edwin

I am fairly new to using access. I have a query that
gives the total calories burned for my exercise program.
I want to create a field that gives the total number of
calories burned. I tried to build an expression, but I
keep getting parameter syntax errors. How do I put in a
simple expression to get the total number of calories
burned?
 
J

John Vinson

I am fairly new to using access. I have a query that
gives the total calories burned for my exercise program.
I want to create a field that gives the total number of
calories burned. I tried to build an expression, but I
keep getting parameter syntax errors. How do I put in a
simple expression to get the total number of calories
burned?
Click to expand...

That depends on how your table is structured. I suspect that a totals
query or a DSum() function call, but since I have no idea how your
table represents the calories I'm not sure just how to answer!
 
Top