By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,952 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

How to report on fields from another table?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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." <gp@westarweb.com> 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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.