Re: Substituting Data on Reports

I think I would create a totals query that groups by whatever field is in
your header/footer and finds the highest priority (or whatever). Then add
this totals query to your report's record source so the appropriate value
would be available.

Again, I would create a table that ranks the priorities so you can use data
to model this. If you can't create/use a table, I would create a small
user-defined function that accepts values like New and Signed and returns the
appropriate priority.

--
Duane Hookom
Microsoft Access MVP


"JoeD via AccessMonster.com" wrote:

Sorry about that. The highest value (in this case "Signed", if found in the
raw data) needs to be displayed in the header and footer; the rest of the
data, in the body of the report. I don't believe filtering would do since I
need all records displayed in the body of the report. I tried using an
expression in a query and met with limited sucess using the IIF command. The
only issue I need working now is to have the selected data displayed in two
locations (header and footer) in the report. It displays correctly in the
footer, but not on the header. I have tried using a non-visible field to
append from for the header and footer, unsuccessfully. I have also tried
filling the field straight from the field list.

Duane Hookom wrote:
Again:
I am also confused regarding just showing one value. Do you want to filter
out some records? Perhaps you could provide some sample records...

No, there is nothing in the table that will aid determining priorities. I
was thinking if I can program some code to assign "Signed" and "New" a
[quoted text clipped - 15 lines]
"New" and "Signed" is the highest priority showing in the query, I need to
find a way to show that in a text box. Any ideas?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200810/1


.

Relevant Pages

  • Re: unlink Footer/Header in VBA
    ... AutoText it will bring the section break with it. ... Header, a footer and Bibliography all in one. ... Bibliography" and another for "Footer for Bibliography". ...
    (microsoft.public.word.vba.general)
  • Re: Header and Footer with RichTextBox Control
    ... I send the footer and header to RTB when it is prining but I ... In that case the RTB will print its contents within that area of the page and you will know exactly what the minimum top and bottom margins of the printed pages will be. ... If the above is approximately what you are currently doing then all you need to do is print the header and the footer within the specified top and bottom margins, normally with the "nearest to the edge" vertical position of the header or footer text about half of the margin size from the edge of the page. ...
    (microsoft.public.vb.general.discussion)
  • Re: MS Word 2007 .dotx can not remember Password protection on re-
    ... (I select the all area of the Document, except Header and Footer to be fully ... Than I put Save as .dot or .dotx. ... before the input the Source code in that Document or what. ...
    (microsoft.public.word.docmanagement)
  • Fixer Footer pro Seite mit schwarzem Rand rundherum
    ... Ich will Mehrspaltensatz mit Header und Footer erreichen, ... ganze Seite mit einem schwarzen Rand umgeben ist. ... | Footer bla fasel di dingsbums und so weiter mit viel Text | ...
    (de.comp.text.tex)
  • Re: Header and Footer
    ... has to create a header and footer in order to be able to activate it. ... See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! ... This message is posted to a newsgroup. ...
    (microsoft.public.word.docmanagement)