How to report on fields from another table?

[Glenn P.]

Sorry, CDMA, I searched this NG on several combinations of words, but
I didn't find a relevant hit, so here's my newbie question:

I have an Access 2002 table which contains data extracted from Oracle
9i for a specific date. The table is then queried and about 15
different reports are generated, based upon those queries. My problem
is that I'm now developing several new reports (I haven't used Access
since 1996) and I discovered that each report contains a label with
the specific date of the Oracle extract.

I don't want to have to manually edit that text label on 15-20 reports
each day the extract is loaded (which typically is weekly, but
somethings it's 2-3 times a week). I created a table called
Master_Date with 1 field (Master_Extract_Date) which is type
Date/Time. I want to be able to insert the extract date into that
field, save the table, then have each report use that field as the
source of the date.

I tried setting the control source on the report field - my original
entry was:

=[Master_Date]![Master_Extract_Date]

However, when I save the changes and close the properties box (or vice
versa) the brackets are removed from the entry and I get the following
error:

The MS Jet database engine does not recognize 'Master_Date' as a valid
field name or expression.

I *have* tried HELP, but I must be missing some Access-specific
terminology because I'm still stuck...

TIA,
Glenn

[PC Datasheet]

Glenn,

Put the following expression in the control source of a textbox on your reports:

= DLookup("[Master_Extract_Date]","[Master_Date]")

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Glenn P." <[e-mail]> wrote in message
news:be**************************@posting.google.c om...

Sorry, CDMA, I searched this NG on several combinations of words, but
I didn't find a relevant hit, so here's my newbie question:

I have an Access 2002 table which contains data extracted from Oracle
9i for a specific date. The table is then queried and about 15
different reports are generated, based upon those queries. My problem
is that I'm now developing several new reports (I haven't used Access
since 1996) and I discovered that each report contains a label with
the specific date of the Oracle extract.

I don't want to have to manually edit that text label on 15-20 reports
each day the extract is loaded (which typically is weekly, but
somethings it's 2-3 times a week). I created a table called
Master_Date with 1 field (Master_Extract_Date) which is type
Date/Time. I want to be able to insert the extract date into that
field, save the table, then have each report use that field as the
source of the date.

I tried setting the control source on the report field - my original
entry was:

=[Master_Date]![Master_Extract_Date]

However, when I save the changes and close the properties box (or vice
versa) the brackets are removed from the entry and I get the following
error:

The MS Jet database engine does not recognize 'Master_Date' as a valid
field name or expression.

I *have* tried HELP, but I must be missing some Access-specific
terminology because I'm still stuck...

TIA,
Glenn