Lately I have noticed any field I left justfy seems to cut off .03 of the
test even though I do not have the margin set for that text box.  This does
not happen on any label, just text boxes.  Any ideas on what it could be?

I'm creating a chart in a report that will show 'Available Time', 'Running
Time', and 'Downtime'.  These are all taken from a query.  How do I change
the name of these columns to 'Available Time', etc.  Just now they are called
'SumOfDaily', 'SumOfSumOfRunning Time (Mins)', and ...

Access 2003 SP 2
Windows XP SP 2
I have created a report (rptFuelmanByForeman) that is based on a Query
(qryFuelmanByForeman).  I have created a form to select (or enter) a

Hello all, I am new to creating a dynamic reports and this is I hope a 1
 time need.  The table I have below is created dynamically the only
things that are constants would be DBH and FLAG.. the other columns
could be anything and any number of them. My question is I want this ...

Is it possible to build a report that will give sums for various categories
within a date range (grouping by category) and also a grand total for the
same date range without creating subreports?  I had a report set up using
subreports but every time I opened the report or tried ...

I have the following data:  what is the formula in a report to subtotal by
lease and payor as follows?  Also can you point me to some good literature on
force a new page and starting the page count over again.  Thanks.
Lease   Payor   Sale date   Amounts

Access 2003
I have dragged two unrelated reports into a main unbound report,
"appendices".  I am doing this to be able to have consecutive page numbers
across a group of reports which form a large appendix for a document.

I have a report generated from an [AttendanceRegister]. On tht report it
shows the [Date], [Employee] and [SickTime]. All of this information appears
on the report. But days where sick time is "0" show up as well. How can I get
only records that are anything above "0" only???

I have a database that someone else wrote and I'm trying to update the
report.  I can't get the information I've added to be displayed in the
report.  I've added my information to the queries and it still leaves it all
out.  I've been working on this for the last couple months ...

A blessed day to you all! I have another question regarding reports.
Let me try to explain this as far as i can..Please bear with me..
What i have done so far..
I have a simple report to display Issue Vouchers for a Certain Site.

I wrote in previous to get information on makin a 3 column report w/out
Fieldnames repeating. The code worked and it is listed below:
If Me.Left < (2 * 1440) Then
  Me![FirstNameLabel].Visible = True

I would like to prompt for "Validate Data"   If the user answers Yes, The
report will check to see if all important information exists, if not, the
backcolor will be set to Grey, if all data exists, the backcolor will be set
to White.  I do all of the data checking with in the ...

I am building a report that gives a summary on all purchase order in a period
of time.
For the report, I have the query set up no problem, but on the report Head, I
would like to make it dynamic so that it can display a company name field

I have been using the following in my query for the report but when the
report displays the data, it's not sorted.  How do I custom sort records in a
report?
Expr1: Switch([Month Quoted]="January",1,[Month Quoted]="February",2,[Month

I would like to set the report page margins on print to .25
here is the code for the print button I am using it uses the current record
log
Dim StrWhere As String