I have a main report with 4 subreports (one of which is nested inside another
one). All 5 reports are based on their own queries due to length of report
and the fact that 2 of them are based on multiple returns from a different
table than the other 3. (5 instead of 2 because a ...

Does anyone know how you can create a barcode linked to some data in Access
2000?

I'm trying to do a free-formed report based which is based on a table, but
I'm adding graphics as I go.  I'm doing my own page breaks and formatitng the
data as I go.  Everything works fine except as I worked my way down the
report I can't go beyond the 22 mark on the ruler.  Is ...

I have a report where I want to hide certain fields if they contain no
information.  I thought it would be and event procedure in on activate in the
report, but can't seem to get the code right.  Is it possible to do this?

Having trouble... want to set up my report so the data will print in
month/year order.  For example, 11/04 before 12/04, 12/04 before 1/05, etc..
or November 04 before December 04 etc...  Right now, it's reading characters
in order - not sure how to fix that. Thanks.

I have a report whose source is a query.  In the query, the Date field has a
criteria prompt for the user to set at runtime.  The report header has a
field whose source is "=[Enter Date]" (which is the prompt in the query).
It all looks and works great unless there are no records ...

I've created a report in Access 2003 and have added a command button to my
main form which runs a print preview of my report.  My question is how do I
allow the user to apply a filter to the data if they want to print only
certain information?  Right now it prints the entire ...

Is there a way to bold particular key words in the midst of other words in a
control box?
Thank you for your help.
Ellen

Hi,
I want to add a combo box to a report.  I have added a combo box to my
report, which the control source comes from a table.  When I then run the
report the combo box doesn't appear??? Why?

How do I place a drop down menu in the report parameter box? I just want to
pick a customer number parameter rather than entering a parameter.

my report record source is a query.. i have a field called amount in there
(in the query).. on my report footer i have the control source = sum
([amount]) - there is nothing wrong with this.. it is working properly.. the
problem is i want this total amount another place on my ...

Hi everyone. I am pretty positive I have done this before but I can't find
any info about in anywhere and I can't remember. I have a report that I want
to print out in columns. My report is only 4.75" wide so there is plenty of
room to double up when in Landscape format for ...

I have:
- ProdTable with Order Number (Order Number is unique)
- ItemTable with item ID per order (there can be many items per order, or
just one - Item ID is unique).  This table has Fabricator also, for the

i have to write a big report and i need a great template that will make it
look good.  i am tired of the old ones that are offered with word
do you know of any other ones where i would not have to pay for them.

I am setting this up in a report.
=IIf([Prod Cat]="PE",Sum([SumOfAssets Under MGMT])-[SumOfAssets Under MGMT],0)
I have two problems occuring:
1. the calculations will subtract the "PE" Prod Cat amount but how do I make