Hello - I'm having trouble dividing our Total Revenue by our Annual Volume to
get the average yield in my report. My formula in the control source is
=([Total Revenue]/[FXSP_ANNUAL_VOL])
Is there something I'm missing? Suming the two rows we're pretty straight

My Line chart shows Fuel usage by over several years.
The grid across the bottom (x axis) shows the month numbers The grid up the
left side shows the amount spent. Each line on the chart represents a
different year.

I have this problem:
I have a grid with 31 columns as days and 12 rows as months. In some of the
“cells” will be letters (A, B, X …). One cell = 1 letter. These letters will
be uploads from users (by form).

I have a report that is running off a table (tblSuperCompliance). The report
has two subreports on it. What's happening is that there are 4 records on
tblSupercompliance. The report will show data for only two of the records.
When I delete one of the records that is showing up on ...

Good morning,
I have a question to pose which I hope someone could assist me with,
I currently have a report running that Groups records together by the week
of a year (A week function that works out the week of a year by from a date)

superscript of report ex( Mey 12 2008) 12 in superscript

used the chart wizard to build a chart from a table source, everything here
is good. But, when the table is appended with new line data this is not
transfered to the chart.
How can the chart data source automatically capture the new table line

I have a problem which I hope someone will help me with.  I have a query
which has the following data;
code     amount
60         $25.00

I have a dynamic qryParametersLast in which I have a field
cboClassification that I must now search through to determine a value
to place in the report header.  In descending order the values for
cboClassification are secret, confidential, FOUO and unclass. If

I have the report done and laid out about as perfectly as I can ask for, but
I have one small problem. When the report prints out, the layout looks like a
Word table, with the bottom part of the table actually laid out in the page
footer section, while the rest is in the detail ...

I have a complex report that has sub reports that are of differing sizes for
different reports.  There is a subform that when it is at the bottom of the
page, a line of text (labels and data fields) prints out with half of each
letter/number at the bottom of one page and, after ...

I have a report that has 2 subreports. The main report is only 1 page long.
The 2 subreports can be many pages and I want to show page numbers on these.
I have put this in a text control in the page footer of each report
="Page " & [Page] & " of " & [Pages]

In the original basic language you could keep track of the number of lines
printed for a page and tell the page to eject when the line number got to or
past a certain number.  Is there a way to do that with Access or Visual Basic?

How can I have a report display a text message upon the first occurence of a
change in the value of a field in the underlying table?  In other words, the
field in this table has the same value for many records in a row, but all of
a sudden that can change and I want to alert the ...

I need to create a complex detail spending report. It has half a dozen
tabular sources, all linked by a two-field set of keys (Project/EquipmentID).
Each of the spending categories is summed up from 0 to thousands of detail
records. I want to be able to print a report (or an ...