OK, I not too sure if what I'm doing is too ambitious: I have a table of
members and in this table, there is a field called familyid which means that
members belonging to the same family will have the same familyid. In addition
there is a familyrole field that I can specify a ...

I would like to know how to reference a control that is located on a nested
subform. Here’s my report layout.  The Main Report contains Sub1 report. Sub1
report contains Sub2 report.  Sub2 report contains Sub3 report.  From Sub3, I
need to reference a text box on Sub2.

For my conference registration db, I need to produce reports listing the
people who have signed up for specific events -- like lunch or a specific
seminar.  Using a label approach, I can make the names appear in 3 columns
like I want but the alphabetizing goes across rather than ...

I have a form that has about 80 items each one has an option group for yes,
no, and N/A.  This updates a table for each itme for each person.  Now I have
a form for the user to create a report, but gives the user options to narrow
the criteria for the report, like date, section, ...

I have a programm, with reports made for A4 page size.
Now for some reports, not all, the page size is changing from A4 to letter.
I changed it many times.. but still....letter.....
?? (the mdb is regularly copied)

I have a form on which a command button allows the user to run a report in
preview mode.  This shows all data for all dates.
I need to be able to allow the user to enter a start and end date and then
pass those values to a query which will then display the appropriate records

I've searched the web and haven't found any info abount drill down feature
for access subreports. Is it available? If yes how do I set it up?
Thanks!

Greetings all,
   I am trying to work on a DB to allow Aviators to track the number of
hours they fly in a given flight period.  I have the following tables built:
tblAviator (contains the following fields)

I have a footer that prints a total for certain detail columns. I'd like to
suppress this footer when there is only one detail line. Is there an easy way
to do this ?
Thanks in advance.

I'm trying to apply conditional formatting to a field on my report. If the
value in a control is bigger than the greatest of two other controls I want
it to display in red else in black.
I cannot figure out how to refer to the report fields and properties. The

It seems there is a page break in my report that I can't find.  Keeps
breaking page when I go to design view.

access 2000
i have a query of data it sortsdescending  2004
                                                              2003 etc....
But the report I have based on this query, lists it in the opposite

I have a sub-report that has 2 side-by side boxes that is creating a gap that
varies in size (from non-existent to large) between records.  The gap seems
to be proportionate to the number of lines of text that occurs in the boxes.
I think the problem is caused by a module I am ...

i am creating an ACCESS report and I need to have the page number reset to 1
when a field value changes.  how do i do this?
thanks.

Hi, I have one report which I want to display with a few differan
sort orders.  I want the user to be able to choose in what order th
report should be displayed, but I don't want to create a differan
report for each order.  From what I've seen an Access report ignore