INTRO
-----
I have a question for hierarchical report.
I have searched the topic, but found some

Help explains using OnCurrent and AfterUpdate for a form -
How do I print a report using a table with the item
information including a text field (255) with a URL for
items picture - ie a different picture for each item from

I have a button that opens a report (SubmittalReport). The record set that
the report is based on does not include one piece of information that I
would like included in the report. I would like to pass a value to a field
called MainFolderName. Below is what I have tried. I don't ...

I have a sub form that pops up asking users to select two
dates (date range: will print all records that are
detailed between these dates) using teh below code. If i
do not enter any dates teh report correctly shows all

i am new to using access what i want to do is using query i want to get 3
names out of the first name field  i.e. i would like to pull out harry,eric
and debbie.. i know they are there but i do not know exactly how to type it
in??. cam someone help me with this?? please

'I have managed to 'group' a field and 'count' the grouped fields,(in a
query) now I want Access to give me the TOTAL count of the fields in a
report.  How do I do that?

I used the wizard to print labels of addresses in access.
If the second line of data (address 2) is blank access
seems to push all the boxes together so I don`t get blank
gaps. I now need to print with the text vertically, so I

I have an access db with 35+ names and addresses. In this db I have a form
which data is entered, of course. On this form I added a command button to
print a report. The report is based on a query that asks for the ID number
to select just one name, address, etc. The problem I ...

Having done a crosstab query, the field Total Of
Quantity: Nz(Sum([ACTIVITY QUERY (1)].Quantity),0)
formats as text.  When I go to run a report which sorts
by Total of Quantity, it sorts likes text (1,13,2,24,3,

To all,
I am trying to make a report showing the input for one record. The
record contains 31 fields relevant for the report. However, some of
the fields might be empty and therefore need not to be shown. In order

I designed a customer account satement report. In this
report for some customers there is no data for calcualtion
in certain period. So I am getting #Error as the value in
sum([Field]) fuction . I tried with Nz function to avoid

I want to draw a line at the first page only conditionally
of the report exactly as the below looks, without
putting/Inserting any additional line control or Text
control:

I want blank records to return a zero in either a report
or the crosstab query the reports based on.  Is there a
simple way to do this?

I have a Grouping withing a Report that may or may not contain a value.  If
there is no value for this grouping field, I want to supress the grouping
header. IOW I do not want it to take up any space in the report.
For example, I have a report that has two groupings: one by country ...

I'm still stuck trying to print a report with variuos text box's borders,
lines, horizontal and vertical.
Lines are shown correctly in preview mode but not printed correctly (or not
printed at all) on paper.