A
Aikiart
Afternoon all,
I've created a report in access where i've put all my fields in the report
header because i don't want the data repeated. I find that I'm limited in
viewing reports that exceed 11 x 14 when I do this. I was wondering whether
there is a way using reports to have data included in the body but not have
the data repeat?
This is a sample of a query I have on one field.
=DCount("[Homeless Status]","PretreatPacerAEC-VA","[Homeless
Status]='Chronic' And [Program Name] = 'Veterans' ")
As long as i just put this query in the header i get a report that inlcudes
the data once, but if i put it in the body, then it is repeated for each item
of data used in DCount.
Ideally i'd like to be able to print the report directly. Currently I have
to transpose the data to a MS/Word document to get it to print.
Thanks for any help.
Art
I've created a report in access where i've put all my fields in the report
header because i don't want the data repeated. I find that I'm limited in
viewing reports that exceed 11 x 14 when I do this. I was wondering whether
there is a way using reports to have data included in the body but not have
the data repeat?
This is a sample of a query I have on one field.
=DCount("[Homeless Status]","PretreatPacerAEC-VA","[Homeless
Status]='Chronic' And [Program Name] = 'Veterans' ")
As long as i just put this query in the header i get a report that inlcudes
the data once, but if i put it in the body, then it is repeated for each item
of data used in DCount.
Ideally i'd like to be able to print the report directly. Currently I have
to transpose the data to a MS/Word document to get it to print.
Thanks for any help.
Art