I made a report to count the number of each type of transaction...I get the
type from taking each voucher and cutting off the first two letters from the
voucher number "Left$([VOUCHER],2)"...the report is created from a query. So
my report looks like:

The solution provided by Sal Ricciardi is what I need help in modifying. He
outlines a way to create a form that can be used to filter a report. In his
example he uses a combo box and two text boxes. My combo box data source is a
select statement that pulls all DISTINCT values ...

I have a report that needs to print detail for unresolved items and in the
footer a count for closed and unresolved items. I need to print the count of
closed items even if there are no unresolved items. So I need the closed and
unresolved items in my report query but somehow ...

When building an expression to string together simple text fields, how do I
put one item in italics while leaving others normal?  I understand that I can
italicize the whole expression from the design view, but instead I only want
the first part of my expression to appear in ...

I have sorted a report alphabetically, by prefix. AA, AB, AC, etc.  How do I
label the header to show the category of records.  I know if I copy the field
that is sorted into the header, it will show the first record, and if I could
format that record to display only the first ...

I'm trying to make a line appear in a report when the EndDate is equal to
today's date.  It is giving me an error.
Option Compare Database
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

I would like to enter the year on a report that I print only once a year....  
I would like a function box to pop up and say "enter year" and then the
report opens and the year is printed in the area I've placed the text box or
what ever I have to do to get the year to print in ...

I am using Access2000 and e-mail report with Snapshot format selected. The
report is being sent as an Excel file (.xls) instead of .snp. The Snapshot
viewer has been re-installed - same problem. Any suggestions???

I have a report created based on one query named sales query which includes
all the information that I need on this report. I like to show some static
information on the report, can I get them from other query or table?
Thanks,

I have a multi-series line graph that is based on a query that calculates the percentage of each series over time. i.e. x-axis is time, y-axis is % (up to 100), there are 5 series - Excellent/Good/Satisfactory/Unsatisfactory and Poor
The query that the chart is based on actually ...

Hi. I created a bunch of mailing labels.  Depending on
what we are mailing out, we would want to change the font
(fancy party invite with fancy party font, every-day
communication with "every-day font".

I have the following groupings on my report : Local, Export and Stock . The
report always lists them alphabetically but I want them to be listed in the
order I have listed above . How do I do this?
GK

Is there a way to create a customized button on my toolbar to print my
report to Adobe Acrobat, and then automatically change the printer back
to my default printer?  I am not very familiar with macros in Access,
but I use Visual Basic all the time.  I have created a macro in Word ...

Does Access have an aggregate function for Median and Mode like it does for
Average?  If not, is there a SIMPLE way to calculate the Median and Mode in a
report?  Thanks.

Hi. If I have a report called rptReport, a Subreport
called rptSubreport and a text box called txtName in the
subreport, what would the On Format code in one of the
main reports sections be if I wanted to make the