I am designing a membership database which also records committees people
serve on. However, I have two separate "sets" of fields where I can put info
in for one person who serves on 2 committees (Committee-1 and Committee-2).
I am battling to understand how to set up a query ...

Access 2003:
Try to open a report to print with the following:
ReportFilter = "PoId = " & Me!PoID & ""
StDocName = "PurchaseOrder"

So far, I have successfully concatenated a full address in a parameter query,
the code is below.  I have a report based on the query. The concatenation is
successful but for the situation of a P.O. Box;  I need the text "P.O. Box"
to appear when there is a P.O.Box involved.

I'm having problem about making report in MS-Access that if the amount is "0"
and then I want it to show in "-" sign. I used the command "IFF" but the
result is "#Error". Could you help me please? The command that I used is
=IFF([amount]=0,"-",[amount])

My report always has 2 pages, and we print Double side (Printer is one side
only - HP1300). In my form, I put 2 buttons: Page1 and Page2. I want to
Preview the report before print it out. So how can you code the Page1 button
to preview only Page 1, and Page2 button to Preview ...

I would like to show a blank row in a report to separate out groups of data
in order for the reader to more easily view the report.  I am sorting on 8
fields in grouping/sorting.  I don't want to add subtotals or force groups to
print on a new page, and I don't need to relist any ...

I have created a report that prints a main section that has the customer
information, including a serial # for each piece of equipment, it also prints
a subreport that reports the components used by that customer.  When I have
just the customer and one component, it prints fine.  ...

Folks,
I have four subreports in a report in the detail section.  I suppose I
could move them to the footer of the report.  Anyway, if any of them
have data, I want the main report to force a page break.  I am trying

I can't read or create a report in Access 2003, however, my coworker, who has
the same software, can.  Any ideas why my computer won't let me?  I can go
through the entire report wizard filling in each section and when I hit
"finished" the computer simply does nothing except the ...

I have ben trying to create a report in MS Access that fills in a
calendar of job/project schedules. I have been searching this topic in
Google groups with no luck, i have been given 1 address over and over
again that does not work, it has no sample calendars as everybody says

I don't really know how to explain what it is that I'm looking to do,
but I'll do my best.
I would like to have a report that will show entries from a table that
have a field that contains a certain number combination in it.  I'll go

I have a chart that pulls the data from a table [SIP Details]. Using a pie
chart I'm showing the different status. The values on [SIP Details] are only
the reference number of the [Status] i.e. 1,2,3,4 and the actual status name
is on the [STATUS] table. Looking at the table [SIP ...

I kinda put a post on here previously but didn't quite make myself clear. So
I'm trying it again.
I have a report that I want to group by Customer ID then sort by descending
dollar value.

I need to create a tabular report in access from a querry that contains 45
fileds. The following message appears: 'The wizard is unable to create your
report or form, because you chose too many fields. Pelase try again with
fewer fields"

I've read through several threads on here, thescripts.com, and Allen
Browne's site and although I've seen several related situations I still
can't quite seem to get this to work.
I have a report that spits out a single job's detail (the job number is