Adding unlinked control sources to reports

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi, I have a load of reports each with two date fields
which will be a pain to update once a year. The dates are
common in many of the reports, so to simplify this, I
thought Id create a separate table with just the dates
(and a form to allow them to be entered) and then get the
reports to grab the relevant dates from the table. I
created the table but when I try to insert it in the
reports query so that I can pull out the fields into the
report, I get a message about ambiguous outer joins,
probably because the new table isnt linked in any way
with the ones already in the query. Is there a way of
adding a control source to a report without adding it to
the reports query? (Ive tried setting up a text field and
using expression builder to point at the required field
in the new table but the report sees this as a parameter
and askes me to enter a value when I run the report). Or
is there a better way of doing this? Thanks, Noel
 
You can use a subreport or possibly a text box bound to an expression like:
=DLookup("[DateFieldA]","[tblLookupDates]","where clause if needed")
 
Hi again Duane. Thanks for the reply. Ill try the text box
suggestion. Cheers, Noel
-----Original Message-----
You can use a subreport or possibly a text box bound to an expression like:
=DLookup("[DateFieldA]","[tblLookupDates]","where clause if needed")

--
Duane Hookom
Microsoft Access MVP


Hi, I have a load of reports each with two date fields
which will be a pain to update once a year. The dates are
common in many of the reports, so to simplify this, I
thought Id create a separate table with just the dates
(and a form to allow them to be entered) and then get the
reports to grab the relevant dates from the table. I
created the table but when I try to insert it in the
reports query so that I can pull out the fields into the
report, I get a message about ambiguous outer joins,
probably because the new table isnt linked in any way
with the ones already in the query. Is there a way of
adding a control source to a report without adding it to
the reports query? (Ive tried setting up a text field and
using expression builder to point at the required field
in the new table but the report sees this as a parameter
and askes me to enter a value when I run the report). Or
is there a better way of doing this? Thanks, Noel
Click to expand...


.
Click to expand...
 
Back
Top