I think i need a formula for my reports...

[JonWardellBuilders]

What formula do i need to insert so that when in my various reports they will
automatically fill in a Job Name or Adress. for instance:

I have an access hub that is standardized, but it gets put to use for 7-10
different Jobsites. I would like all the reports that my guys want to print
out to automatically have there job information at the top. so i need a
formula that is basically, 'make this word be whatever word is inserted in to
this table(or query).'

I have a section that they do first that is job set up, so when it
populates, i want my many reports to populate for them. How do i do that???
Thank you!!

 

[Carl Rapson]

What formula do i need to insert so that when in my various reports they
will
automatically fill in a Job Name or Adress. for instance:

I have an access hub that is standardized, but it gets put to use for 7-10
different Jobsites. I would like all the reports that my guys want to
print
out to automatically have there job information at the top. so i need a
formula that is basically, 'make this word be whatever word is inserted in
to
this table(or query).'

I have a section that they do first that is job set up, so when it
populates, i want my many reports to populate for them. How do i do
that???
Thank you!!

If I understand what you're asking, it sounds like you could place an
unbound textbox control in your report (or page) header section, with a
Control Source something like:

=DLookUp("[Job Information]","[Some Table or Query]","conditions that
determine which job information to use for this JobSite")

Carl Rapson