Hi,
How do I give a Label in a report the name of say, the first column in a
table? It the name of the column change, the name of the label in the report
must also change.

i need to print 12 midnight inmilitary time 2400 hours.  i will not print
out. i have to use 23;59pm

I have set up large table and forms with multiple fields. Some of the field
would contain several lines of text . I have created report, but it trunkates
all information. Even when I export this report into Word, the fields are
still trunkated. How can I avoid this.

taAccess2000
I've created a report where I enter the desired dates worked for any given
period via a parameter.  Its based on on a query containing the names, hours,
job, rates and exemptions, etc).  When I run just my query I get a list of 59

Is it possible to sort on an unbound text field on a report?

I have a report that counts items from 4 separate tables that are created
using a macro that runs make 4 table queries.  
Each item is counted using a DCount expression for example:
=DCount("[SSNumber]","tblIntakeBarriers","[PARTIndividualwDisabilty2] = 'Y'")

I have a report based off of a query.  In the query, there are these fields:
NumberReturned
Lname
Ques1a

I have report that I created using the Report Wizard.  It shows all of the
fields from my table, just like I want it to. When a record in my table
contains all completed data, I want all of the fields to show.  Records in
my table contain completed fields AND incomplete fields, I ...

I have a client lis report in a database. I have sorted the data
Alphabetically and wish to print the report alphabetically, one page one
letter of the alphabet. is this possible?

I searched this site for a solution to printing a subreport even if there is
no data.  None of the solutions fit well in my circumstance, so I came up
with this solution:
I left joined in a table to my stored procedure that I knew would always have

Using Access 2003.  I have a report that just lists (up to) six columns of
(up to) five rows of calendar dates.  Each column consists of dates within a
week.  The record source is a simple query consisting of calendar dates and
their associated "week parts" and there is no code ...

I rather rudely hijacked another thread with this problem.   I'm sorry about
that. So I'm going to post this on it's own thread so I can stay off of the
other thread...
I have picked a lot of brains on this one and it seems that there just isn't

I have developed four different queries (one for each quarter) that display
the data I want.  I have created a subreport for the first one, and since
they are all the same (I might change the others later to work all in vb, but
baby steps), I would like to use the same subreport, ...

Is there a way to construct or insert a "table" into an Access 2002
report similar to a Word table? I would put labels in the upper row and
data links in the lower row.
Thanks

I need to create a report in Access that displays / prints like a calendar
and have job information from a database table inserted into the appropriate
date area corresponding to the date on which a job is scheduled.  Does anyone
know where I might find examples of such a ...