I notice that on my report I can not choose "can grow"
option under properties of a text field that happens to be
a drop down box in my table.  help?!
TIA

I am using access 2000
My mind is not with me today.  I have a report that
usually prints one quote form at a time.  But now my boss
has asked to be able to pull up all the quotes for one

I have 4 fields: StartDate, StartTime, EndDate, EndTime.
The date Format is dd-mm-yyyy and the time is military,
hh:mm
I would like to calculate the difference or the elapsed

If I have a section in which all fields are empty, no data, does the format
still allocate space on the page for the section or does the section height
become 0, in other words shrink up.
Thanks

Is there anyway to split and export a report by group headings?
I have a database that contains 20 names, I really need a way to export the
data from the table/report into separate excel files. any ideas?
TIA

Hi, we are a group of students creating a database of a
collection of photos. We have a field that we have
named "code" which is a mixture of numbers and letters and
will contain information on the location and number of

When testing code behind an On Format property of a group header I notice
the Top property setting is 630.  I use  ?ctl.Top  in the immediate window
of access 2003. Yet when I try to set the top property for a control in the
same group header I get Run Time err 2100. Telling me The ...

I am generating a report and I would like to limit the
exact amout of rows that the report shows.  I can't use a
Top X query because the report contains multiple groups.  
Each group can have any number of records under it.  If I

in the report I am working on I have a lot a expressions. In a few of the
fields I need multiple expressions. The first expressions read: if this
report is on this person(s) insert NA. That part works fine. But now I am
trying to add a second part that reads: If the value of this ...

I want to count total number of record on a particular
page at Page footer. As all the pages of my report does
not carry the same amount of records . I tried to put a
text box on page footer and on control source I wrote :

Hi,
I wonder if someone can help me
I have a table with sales and expenses, the sales have
negative signs and the expenses positibe signs.  

How do I change the sorting and grouping for report in VBA?
I have a report that I need to sort two different ways based on different data in the query.  I have set up the sorting and grouping for one way but cannot figure out how to do it for the other way, other than creating a ...

I went to the Microsoft Knowledge base to try to get the
round up function and they gave me this code.  I have used
this to round up but it is giving me one error.  
Here is the code.

I've created a 3 1/3 x 4 label report using the label
report wizard. I modified the layout for our return
address. The label printing is inititated from a command
button on a form. On the form is list of orders to print

I have a subform on a form. On the main form I have a button that I want to
use to print a report with the fileds of the whole form including the ones in
the subform.
Please help