Hey all,
I have a report based on a crosstab query.  I would like to convert
null values to zero or one so that some calculations work properly.  I
have seen numerous questions and answers related to this question but

I have created a number of weekly reports.  I would like to provide a way to
print all of the reports with one simple command.

I have a counter on an Access report that increments when a particular
condition is true at the detail level (using vb code in Detail_Print).  I
initialize the counter in Report_Open subroutine.  When viewing the report in
preview mode, everything works well with the counter ...

Hello can someone please help me, I'm fairly new to access and am trying to
change a formula built into a report.  I'm using expression builder in the
report.
In English the calulation would look something like:

I found an answer on another question that I think is getting me closer, but
I am still getting errors.
Currently, on frmBugs, for the field CreatedBy, the user selects from names
displayed in a combo box (cboCreatedBy). The source of those names is: SELECT

Is it possible to have 2 queries in the same report?

Hello, I'm very new to Access and need some help pleas:
I'm trying to calulate VAT and put this on the form, but only if the
supplier name does NOT contain the characters JCA.
So in English logic it would look something like this:

As a relative novice, I have got quite good at using IIf statements in my
reports.  However, I can't find a way of resolving the following problem:
I need to print text according to the value of a variable LEFT([syll],1).  
If LEFT([syll,1] = "0", I need to print "BGCSE"; if ...

Hi group,
I've done a query to list all events, grouping by the month.
By this query, i've used the format() command to transform the date on
month.

Hi, I have a table which has clients' names and addresses. I need print
label for selected clients, but the difficult thing is some clients' label
need be printed 3 or 4, some just one. How can I create such label print?

I have a report, written in Access 2000, but running on windows 98 machine
that there is one report that I use to print labels, it would lose its
formatting info. once in a while.  Can anyone help?

I have a report based on a single table with groups on a date field by month
and year. In the date by year footer I want to include a text box with a
value given by a query (a TOP 1 query that returns a single value). I can't
figure out a syntax using either the query name or the ...

I have a report with 2 subreports in it. Some of the records which make up
the data source for the report have records to populate the subreports, some
do not. Is it possible to not display the subreport for a given master
record if there are no records within it? Take this example.

I want to left justify the data in a report that has boxes around each
field, but the first letter of each field is too close to the left side of
the box.  What is a simple way to left justify all the fields with a small
indent (e.g. one blank space).

How do I use two queries in one report.  If I base the report on only one of
the queries then I get an error when I try to use a total from another query.
I can't figure out what I'm doing wrong.