basic expressions

  • Thread starter Thread starter Edwin
  • Start date Start date
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?
 
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!
 
Back
Top