I am new to Access and looking for some guidance.
I am currently developping an application in which I can manage customers
and the work I perform for these customers. Each month I need to produce a
report summarizing, day by day, the work I performed for the customer. The

Hi to all,
I am having a problem using the NoData event on a report. On occasion there
will be a report being run by a user and that report might have no data when
some filters are being applied.

I have created a recipe database. My recipe report prints 4 3x5 recipes in
landscape on 11 x 8 /12 page. My header contains the recipe name,
description, calories. My detail section contains a subreport of ingredients
(3 columns) (set to "can grow = yes") and a directions memo ...

I obviously have difficulties with explaining my problems on this discussion
so I would like to send someone my database and tell them whats wrong so they
can see it......any volunteers??

How do I write an event procedure to do this:
On Open
I want it to show only Current User's Records?
Thanks

Got 5 Tables.
Table A is related to Table B,C,D and E.
The 4 underlying tables keep information related to date and time. Ex: Start
time of project goes into A. End time of the project will go into Table E.

I have searched for this and have not found a solution. I am sorry if this is
a double post. I am trying to group a report using the first 1 or 2 numbers
in a field. The field [CMG] can be 3 or 4 digits. If it is 3, I want the
first digit, 4, the first 2 digits..

Does anyone know why if I export my report to word that the picture that I
have in my header disappers?  Does anyone know how to fix it?

Using Access 2003...
I have a master report (rptMaster) that has the header and footer I want for
every report.  This master report also has an unbound child window.  I create
sub reports that I use to actually populate the reports.  I want to

Hello all.  I have created a report that has page header and footer
sections, a group header section, and a detail section.  The group
header is a vertically oriented right aligned sidebar that is the full
height of the printed page, minus the height of the page header and

I searched for and read posts on this group regarding using the Nz function,
but I can't seem to get it to work for my purposes.  In my report, I have a
currency field [Cost].  I want to show [SumOfCost] in the report footer.  The
report is filtered by date range.  If there are ...

I want to sort the records in a report in a nonconventional way... I want to
sort all records that have been assigned a value of 14 first, then 18, then
13 down to 1, and then 16-17.  How do I do this?  I set up a different report
for each of these scenarios and then added them ...

I have a report that a user can click to view on a report menu.  I would like
them to be able to enter 2 different dates (i.e. view data between July 1,
2005 and October 31, 2005) and have the report only show that data.  How can
I program the form to pass this data to the ...

I've had a problem on several databases I've written (multi-user) where the
default settings for printing keep cropping up despite new ones being set and
saved.  It seems to come and go.  Does it have something to do with users
having different kinds of printers?  It may work ...

Is it possible to rotate the text vertically in a report label to read from
lower left to top right, rather than top right to lower left?  I did not see
an option to change in the properties.  
hope this makes sense.