G
Guest
Hey all
I work in a media library, which collects and holds onto software packages.
These are identified by a serial number in our database (i'll call it D4).
I have a report, based on a query, which details the information on these
media.
When you run the report, it is setup to prompt for up to 5 different
criteria (the D4 number) which appear on the report. The report is grouped
by D4 number. The layout/sections in design mode goes (top to bottom): Page
header; D4 Header; Detail; Page Footer
Here's my issue:
Normally we run the report, then export it as RTF to be able to insert
additonal formatting/notes. In the D4 Header section, there is a label
called Notes, where when we export it, we fill in the info in Word. What i
want is to be able to put in a unbound text box beside it and be prompted for
the notes for each D4 number, so they appear in the report automatically.
These notes are only used by another department in creating a letter, so we
don't want to create another table to save them in. I just want to be able
to inject them into the report on-the-fly, so I don't have to then mess
around with editing it in word. I hope this makes sense and thanks in
advance to anynoe who can help. I'm using Access 2000 (i know, i know, it's
ancient, but i'm stuck with it here
I work in a media library, which collects and holds onto software packages.
These are identified by a serial number in our database (i'll call it D4).
I have a report, based on a query, which details the information on these
media.
When you run the report, it is setup to prompt for up to 5 different
criteria (the D4 number) which appear on the report. The report is grouped
by D4 number. The layout/sections in design mode goes (top to bottom): Page
header; D4 Header; Detail; Page Footer
Here's my issue:
Normally we run the report, then export it as RTF to be able to insert
additonal formatting/notes. In the D4 Header section, there is a label
called Notes, where when we export it, we fill in the info in Word. What i
want is to be able to put in a unbound text box beside it and be prompted for
the notes for each D4 number, so they appear in the report automatically.
These notes are only used by another department in creating a letter, so we
don't want to create another table to save them in. I just want to be able
to inject them into the report on-the-fly, so I don't have to then mess
around with editing it in word. I hope this makes sense and thanks in
advance to anynoe who can help. I'm using Access 2000 (i know, i know, it's
ancient, but i'm stuck with it here
