Good morning,
We have an access database that has the tables, forms and queries all
completed.  We have a small portion of the data entered to test things out.  
We need to create a report that is comparative by year and by number of cows.

Is there a way to suppress a field if it is blank?  If so, how?

I have a report that lists the total number of hours worked by each employee
for a particular program.  Some employees work in more than one program.  My
report gives me the correct totals for each program, however, I want to add a
grand total of the hours worked for all programs ...

I am modifying an Access 2000 database in which my "qryMB59" query is merging
a table to show one other piece of information and an older query "qryMB51."
When I run MB51 for a particular day, I get 54 results; but when I run the
new MB59, I only get 44 results because there are ...

I have created a button on my employee info form to print about 6-8 reports
based on the employee number and have used this code for the on click event:
Private Sub PRINT_DOCS_Click()
Dim strWhere As String

I have a main report with 3 subreports and I want to display totals from
each subreport and grand totals in the report header of the main report.
What is the best way to do this?
Allen Browne posted the following response to a user back in 2003

For some reason when I go to print my report, it runs the queries again.  Is
this supposed to happen, the data is already on the page?  Why would it need
to get the data again?  This means that every time I want to view my report
before I print it all 6 queries that build the ...

I have a report that is failing to produce a value for some records in the
final calculation column. The data is populated in the datasheet view of the
query. The strange thing is, I produced a simple report for the purpose of
visually validating my calculations and all values ...

I need to have a seperate fonts in the same text box for one of my reports.
Here is my text box below.
=Trim([L_Name]) & " " & [footnotes]
I want to have [Footnotes] in a smaller font. Please let me know if there is

In Access 2007 how can we  pass  values from a Listbox to a Query as criteria.
presently I am using a Command Button to call a Macro which displays Query
in Povit Chart View. I want to you a ListBox insted Command button so user
can filtered data.

I have two parameter queries that create the output I'm looking for. Both
queries use the same input.  I now want to combine these two queries in one
report such that the complete results from the first query is printed first
and the complete results of the second are printed ...

If anyone would be willing to accept a screenshot of my report results, that
might better describe my issue.  But, if not.....I have a report that sorts
and groups products something like this and sub-totals the product form:
20oz Ravioli