I am trying to pull a count of records that is not in the same table as the
record source of the report. The only way to do that is to use dlookup right
now through the expressions box in the controlsource. Dlookup is not
flexible. How can I use queries in this text box? ...

I want to download the www.pokemon.co clip art for my homework use but i
can't .Why?

       I need the functionality of the system print dialog, and I see that I
can open it with a simple DoCmd.  I'm wondering, is it a bad idea?  Is it
difficult to get value to and from?
       I just seem to notice a lot of folks talking about doing things like

Access 97 - I have a subreport that needs a page break
after a footer section.  I have the page break inserted in
a footer and it runs just fine if I run the subreport by
itself.  But when I run the main report that contains the

In Access 2000:
I've set up a specialized report for my boss that creates a bar chart of
different customer count numbers over time.  I set up the report to group
according to different shifts, and then according to different areas.  

How do I get a label to be viertical with text from the lower to upper.
When I set lbl.vertical = true the text is from top down.

Is there a way to let the user customize reports with a selected amount of
data fields?

Can anyone help?  - My Access (2003) suddenly became unable to either open or
create Reports.  Everthing else is OK.  I have re-installed the whole of
Office & the problem still exists.
My Apps work on other PC's with Access 2003.

I am trying to make address lables in new reports and after I do all the
selecting (type of label, what is to be displayed) it says do you wish to see
your labels...I say yes and a window pops up that says enter the paramenter
values (OK or cancel) and when I click either it ...

In Access97, using MSGraph 2000, I'd like to add a secondary
(Z?) axis plot to my Bar Chart.
My basic Bar chart works fine, and shows the count (y-axis) of 35 different
defects (x-axis) for a particular product.

Is it possible to create a crosstab query that has more than one column
heading.
I need to generate reports that have data from a table/query field that are
the headers of the report spreadsheet.  Now a crosstab query would solve

My database is for a food bank.  I have a Client table (contact details etc)
and a linked ClientHistory table (date, food parcel details, budgeting
details...).  If I open the Client form at Joe Smith, I want to be able to
click a command button that opens a ClientHistory report ...

I have created a table, report & form with 40 questions, each questions has a
lookup field with 3 possible answers (satisfactory, unsatisfactory & not
applicable). I need to total how many times each employee used each answer.
Example: Total: Satisfactory (5) Unsatisfactory (3) ...

...I based a report on a Sum of Payments Query......
SELECT DISTINCTROW Payments.MemberID, [AFBA Members].[First Name], [AFBA
Members].[Last Name], Payments.PaymentAmount, Sum(Payments.PaymentAmount) AS
SumOfPaymentAmount, Payments.PaymentDate, [AFBA Members].CardsIssued,

I have a report based on a crosstab query.  The report has too many columns
to fit on a 14x8.5 page.  As a result, every other page is a continuation of
the previous page, but I loose the first column (row header of the query)
which would make the report easier to read.  Has ...