Creating good dynamic reports
Sat, 22 Nov 2008 03:40:01 -0800
I have a report that is made up from serveral subreports. My problem is
formating the report is really difficult as the contents can vary so much. I
have tried but cannot find a way of testing for report content and then in
some way adjusting the formating of the report base on it's contents.
Any suggestion ...
|
Fields disappear due to code
Fri, 21 Nov 2008 14:57:01 -0800
I have a report that is comprised of a number of performance measures. Some
measures are Yes/No responses while others are Numerator/Denominator
responses. I have the code (below) in the On print portion of the Detail
section of the report.
My problem is that once the event is triggered to make the fields ...
|
Start Date + 7
Fri, 21 Nov 2008 11:57:02 -0800
I have a report that I want to have list all the Mondays of the month on one
report and the Tuesdays on the next report. I added an unbound control
Start Date on my report and tried start date + 7 on another control, but that
didn't work. How do I do this? Thanks for your help..
example for just Friday ...
|
Report Datagrid, Repeater, or ???
Fri, 21 Nov 2008 11:23:00 -0800 (PST)
Hi.
I'm using Access 2002 to create a report from 2 tables: Customers and
Orders. Basically, I want the report to list info for each customer.
Under each customer's info, I want to list the customer's orders. For
each order, I just list the date and total price. Simple stuff,
but ...
I want to put several ...
|
record set not updateable (3326)
Fri, 21 Nov 2008 17:22:54 GMT
I have a form with its record source as a query.
I want to total 3 of the numeric field on the form and update a 4th field
with the total.
I have done this already on onather form and all works OK.
This tme I get the error
"You attempted to edit data in a field that is bound to a snapshot-type
result set ...
|
Wierd characters showing in memo field
Fri, 21 Nov 2008 09:19:00 -0800
I am getting wierd characters(Japenese) in a memo field on my report. I don't
see any problems with the properies and the records have no data in the
field. Any idea why it is happen? ...
|
AVG on time on a Report Group
Fri, 21 Nov 2008 08:10:04 -0800
I have records with a time field in it and have a report that groups the
records by date and attempts to average the time. It works fine (although it
comes out decimal instead of minutes) on some records and not on others. I
have checked this out manually and it surprises me that my results are so
inconsis ...
|
|
|
With First Detail - Unexpected Results
Fri, 21 Nov 2008 07:22:19 -0800
When I select "With first detail" in the "Keep together"
property in the Sorting and Grouping dialog, the results are
more in keeping with what I would expect from selecting
"No". In other words, the result is that if there isn't
room for all the details on the current page, they get
bumped to the next page.
...
|
converting Access2003 report into PDF format in stead of SnapShot
Fri, 21 Nov 2008 06:15:01 -0800
How can I convert an Access2003 report into a PDF file in stead of the SNP
format or HTML format ??? I need the graphics also, so Excel of Words is
useless too. ...
|
yes/no total
Fri, 21 Nov 2008 01:51:01 -0800
Hi
I have a report based on query which has field Analysis from table data type
Yes/No and would like total for yes selection
I tried following in control source of textbox
=IIf([Analysis]="Yes",Sum([SumOfQuantity]),0)
but get result 0
so thouht value of yes maybe 1 so tried
=IIf([Analysis]=1,Sum([SumOf ...
|
