I am designing a report of about 8 pages.  I have made multiple pages on the
detail section, however I have come to the end of the detail height of 22
inches.  How can I add more pages on the detail section?  The page limit of a
report is 65,536, yet a detail height limit is 22 ...

Bear this in nind - I'm a beginner with Access
I've created a Query with a paramter [Date]
I have created a Report based on the above Query with a Dialog for the user
to enter the desired [Date] value via a date-picker.

In my database I have Canadian and US patients.  For US patients I want to
hide the final page of a report, on that page are a graphic, a few labels and
a sub-report.  Some of the items don't have sources so I can't use IIF in the
source.  Is there a way I can do this?

I have a report designed where on the same line there are
two text boxes, e.g [Title] [Date]. I want the date to
appear at a fixed length from the title, as the length of
the title changes from record to record. I remember that

I have a report that queries 4 tables:
tblProfiles
tblPKCGPhysicalAttributes
tblPKCGMaterialAttributes

I would like my report to count or sum all checkboxes that are checked
(True). What would be the syntax?

When filtering a table how do I display only filtered results in an existing
report.
Any help gratefully received.

I have created a report that uses check boxes. I need to know how to add or
count the check boxes that are "true." I am using the count function, but it
counts all of the boxes, not just the "true" ones.

If anyone could help it would be great,
My report is setup like this:
subrpt1
subrpt2

i type filter criterion in access report and put the filter 'on' but when i
save it, it goes away when i open the report the next time.

Is it possible to put the value from a report control into a form txtbox?

I am logging the amount of time in minutes that it takes to do a particular
task. I have the time that a task was started and the duration for the
amount of time that was taken. What I would like to do is store the amount
in minutes and also show how many hours/minutes the task ...

Please help.
When I create a report the data in the report seems to be drawn from the
data shown in the current table. However if I change the data in the table by
applying a filter the report does not update. I think I'm missing something

I keep getting errors in my search button code. can any one tell me
whats wrong. Error happens clear at the bottom in this code :
"Select * from workorders " & (" where " + Mid(varwhere, 6) & ";"))
DoCmd.OpenQuery "Dynamic_Query"

Hi to all the NG.
I'm the first time here.
I build an interface(a Popup Form) to give to the user
the capability to Formatting Preview with no required