File & path Name in Footer

[Sapper]

O.K. I know it can be done in Excel (=CELL("filename"), but what is the
equivalent in Access?

I work on a network, so my files are kept there and keeping track is a pain,
being able to see on reports in the footer just where the files are would
make my life so easy.

TIA, Colin

 

[Marshall Barton]

O.K. I know it can be done in Excel (=CELL("filename"), but what is the
equivalent in Access?

I work on a network, so my files are kept there and keeping track is a pain,
being able to see on reports in the footer just where the files are would
make my life so easy.

Which files? Access can utilize many (back end) databases
and other files for the data tables.

The path of the (front end) database with the report object
can be retrieved using:
=CurrentDb.Name

 

[Sapper]

1 for 1, that's exactly what I was looking for.
It works a charm...........
Thx,
Colin.