Hi I have some data as follows in  a table called job
Job number
1
2

I created my first crosstab query.  The crosstab query is designed to
calculate the total amounts paid to our customers by year (i.e. in 2005 Joe
Smith recieved $5,000).  The information is displayed as follows:  rows are
customers and columns are the years with the totals.  When ...

I have several queries that all return the same data fields and require the
same report layout. I was just wondering if there was a way to simply have
one report instead of a report for each query. At the moment i simply have a
form with several buttons corresponding to the ...

I want to change the "Units in Stock" field in the Product Summary Report.  I
can't seem to figure out where that field is or how it is calculated.  I want
to take out subtracting "Shrinkage".  Thanks

I am using a subreport and the column heading show in the page header of the
subreport but do not show in preview mode.  Any ideas?

Is there a way to set the recordsource of a subreport through code?
I have got a form that I am wanting to use for setting the criteria for a
query to view a report by.
I am having problems with setting the recordsource of the subreport.

How do I get the Report Footer to print at the BOTTOM of the last page after
the PAGE footer.
Isn't that where the Report Footer is supposed to go?
If I can't do that, How do I get a footer at the bottom of the last page

I'm stuck.
In the detail section of my report.  I have two fields, Revenue & Hours.  In
the footer section I want to divide the sum of the Revenue field by the sum
of the Hours field and display the results in another box.  What would be the

An Access app produces a few reports that include the company logo as bmp
picture. A couple of users see an incomplete pic/logo on their screen )print
preview of the report) as well as when printing it. I don't seem to be able
to reproduce the problem.

I have a report showing Building Permit primary key ID's with hide duplicates
set to yes.  On this same line I have subform data that prints the BPermit
Payments primary key ID's.  When people buy BPermit extensions the data goes
on a subform and  there is a new report line ...

Are you able to divide decimals in the footer of a report?

I have a report which has a paremters box which has you type in the name of
the customer and then it comes up with all the job orders that customer has
ever had with my company.  however spelling seems tobe a major problem.  Does
anyone know how or even if I could have a drop down ...

I am building a report based on a Query that is built on several related
tables. Some of the fields have a list of choices when data is being entered.
Instead of returning the values in the related tables (which is what is
returned when I run the query), the report is returning ...

I created a report in Access 2003 using the Report Wizard. In summary options
I chose Detail & Summary. Can I change it to Summary only now that it has
been saved? How? Thank you for the advice.

This question deals with the report and the underlying table.  I am entering
information in by Grid ID (ex. A25, A26, B5, C10).  So, the report prompts
you for a Grid ID and everything about that grid shows up in the report.  
My question is that in the Grid ID column, if I ...