I have created a report that compares production data from one qtr to the
previous qtr.
It is based on a crosstab query that sums the production numbers by qtr.  I
have a parameter that prompts the user to choose which years production data

My manager ask me if I can highligth a text box in details section of
my report if a there is data
If anyome knows how can I do that. Please help me,
Thanking you in advance for your help and support!

my table has a date/time field. when I datasheet it , it shows date in format
dd/mm/yy. In my report I want to filter the date field on 8th Feb 2008.
If I set filter to tabdate = #08/02/2008# it doesn't find any records,
however if I put tabdate = #02/08/2008# it finds them fine.

I just added group footer to and a sum field to the data in the group.  The
problem is that it will sum part of the group and then sum the other part.  I
tried changing the "group on" property to Prefix characters and each value.  
Group on prefixed characters groups all of the ...

I posted a question a couple of days ago and have not yet received any
answers.  Therefore, I'm wondering now if anyone knows of a good place to go
to get the answers I'm seeking regarding what's probably a complicated
calculation in a report (concerning calculations when working ...

I don't use Access reports very often, so please excuse the stupid question.
I have several controls that are (or should be) showing numeric values on my
form.  However, if the field is null, they don't show anything.  That's
fine, sez I, I'll just change the data bound to the ...

Is it possible to insert a page break in a report header?

   Trying to do a report based on a form/subform. Did a query to include
all data from form and subform and made a report where everything shows up
fine and is grouped as I want it. BUT. I can sum data from the report detail
section just fine but cannot sum data that is in the ...

I have a report that shows much data about a single record that I am trying
to reuse from a previous database.  In my new DB, the project manager is set
in an intermediate table between project data and contact data.
How do I reference a table outside the forms data source?

Hello, I created a report base on a crosstab query.
The report will show the sales focus change.
January focus for the next 12 month,
February focus for the next 12 month, and so on.

I have a report which is based on a query. The query is this:
SELECT DISTINCT tblJobTickets.JobNumber, tblJobTickets.JobName,
tblJobTickets.intJobID, Max(tblJobTickets.TicketDate) AS MaxOfTicketDate,
Max(tblJobs.intQuantity) AS MaxOfintQuantity

I had created a report and imported all fields from a table. This table was a
data table of imported data and I had not yet finished cleaning it up in case
I decided I wanted something from it.
I deleted the fields on the form the referenced data in a table and then

I asked and received the below advice for how to print a set of labels
one-time only, below the page header.
This code does do that.  But, it leaves all the white space reserved for
this on each successive page.

is it possible to print the totals of a report, only? with out the date?
Thanks!

Could anyone tell me how I can have the header of my report to print on all
of the pages of the document and not just the first page?  
Thank you.