When I create a chart, no matter what I do to resize the chart, it gets cut
off at a certain point.  It doesnt happen with reports, only charts.  It
seems that there may be something with the OLE object embedder or something?
I've tried uninstalling access and reinstalling but it ...

Can I dcount crosstab query?
If not, how can I count the record count of crosstab query?
Your information is great appreciated,

Hi Groupies
I know this has been asked before but I can never seem to find an actual
answer.
I have an image selected in a record via a hyperlink. The field is called

I have a report that If there is not data to print, I would like to display a
message indicating that there are no record to print. I'm able to use the
nodata event to display the message but I still open the blank report in
preview mode. I included a Docmd command to quit the ...

I have a report using crosstab with parameter.
The reprot works without parameter.
The report does not give me fields list to choose when I use report wizard
with parameter.

I would like to create a chart based on a query with data like:
Year x1 x2
1998 71 4
1999 84 5

Does anybody know how column headings can be displayed vertical to take up
less space on the page rather than horizontal. Is it possible? As I have too
many columns which i need displaying on one page in my MS Access Report. Can
anyone give me any suggestions?

I have been using   doCmd.OutputTo acReport, stDocName  to send a report to
a file.  Using Access2003 this command would give me a list of file types to
select from, txt xls, rtf, html, etc.  The same mdb, running in Access2007
on a different computer, is missing the xls file ...

I have a form that sets up filters for a report.  One is a dropdown box of
the different offices that information is being tracked on.  What is the best
way to add a choice to the drop down which says Nationwide and encompasses
all the data from all the offices combined.

I have a few ways where a product can be sold, I want to be able to create a
report in a way that I can view the product and the certain way it was sold.
Can this be done?
Thanks in advance

I have created a reprot for the college that lists all room assignments with
data that our scheduling assistants will need. I would like to change the
text color of the course title to RED if the class text is = Like "CANC*"
Is this possible. (I am using 2007)

I divide 2 IIf statements. They work fine as long as no null is present.
Here are my statements:
=Sum(IIf([Findings]<>1 And
[Month]=DateAdd("m",-4,Forms.ReportCriteria5.txtEndDate),[ErrorAmnt],0))/Sum(IIf([Month]=DateAdd("m",-4,Forms.ReportCriteria5.txtEndDate),[Allot],0))

I have a text field that contains the following values and sort in this order
138-1
138-10
138-11

I've created a form in Access 2003 that uses the Calendar Control.  It
grabs a date, then on a Button Click event, the following line is
executed:
   DoCmd.OpenReport "Report X", acViewPreview

I have a need to include 5 different tables in one report. I created a query
but it would not allow multiple links in one query, so I created multiple
queries useing the preveious query with the next table. It worked good till I
added the last query to include the last table. ...