Find which tables/queries reference or calculate a particular column 1

[KenCunningham]

Good afternoon, I'm trying to find tables and queries in an Access database which reference or calculate the column 'AgeBand'. As far as I can see this is a derived column, but there doesn't appear to be any clue on the form it is used on as to it's origin. This is a fairly trivial exercise in Oracle/SQL Server, but doesn't seem so in Access.

Any help appreciated. I am away from the office for the next day or so, so please don't feel I am ignoring any answers posted. I will get to them on my return!

Thanks.

The internet - allowing those who don't know what they're talking about to have their say.

 

[PHV]

Have a look here:

http://mdbdoc.sourceforge.net/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[KenCunningham]

Thanks PH, you're a marvel!

The internet - allowing those who don't know what they're talking about to have their say.