Total labels

  • Thread starter Thread starter Gerald Mikolajczak
  • Start date Start date
G

Gerald Mikolajczak

My report currently shows a total line as: Total: xxx.xx xxx.xx xxx.xx
I would like it to read as:

Total rides: xxx.xx xxx.xx xxx.xx where 'rides' is the data retrieved
from the database. rides is contents of field name 'games' within the
database 'activity'.

I've tried Total: &([games]) and get an error.

Thanks for the help.
 
Gerald said:
My report currently shows a total line as: Total: xxx.xx xxx.xx xxx.xx
I would like it to read as:

Total rides: xxx.xx xxx.xx xxx.xx where 'rides' is the data retrieved
from the database. rides is contents of field name 'games' within the
database 'activity'.

I've tried Total: &([games]) and get an error.
Click to expand...


If the Activity table is the report's record source, then
you can just use a text box with the expression:

="Total: " & Games

If the Activity table is not the report's record source,
then you'll have to look up the value of Games. If the
Activity table only has one row, use

="Total: " & DLookup("Games", "Activity")

If the Activity table has more than one row, you'll have to
describe how you determine which row to use before I can
figure out how to select the right one.
 
Back
Top