|
Report Challenge
Hi Folks - Here's the situation .....
Let's say this is a medical test database. A doctor can order up to 10
tests. Sometimes they order 3 tests, sometimes 9 tests, etc. It would be
easy for me to create a report that lists the number of tests per doctor.
However, I need to produce a one-page report that lists all 10 tests, then
count the number of times that the doctor ordered the test...
|
6 |
22.09.2006 20:32:05 |
|
|
Reports and sub reports
I have several sub reports put into one report. They are all based off of the
same select query. The select query requires that I enter the criteria before
it runs. When I run the report it makes me input the same criteria for each
page of each sub report. So I end up entering the same data a bunch of times
to generate each page of the report?...
|
4 |
22.09.2006 18:35:13 |
|
|
access report color
i have found that when i print an access report the color portion is pale.
conditional formatting within the report does not print at all. i have set a
specific printer & changed the printer output to "Best" but the colors are
still faint or non-existent.
thanks for your ideas....
|
2 |
22.09.2006 18:31:02 |
|
|
page footer calculated field
In a footer section I have a report summary, with total quantities, amounts
etc.
I need this summary to appear always on the page footer.
So, I have moved it from the section footer to the page footer.
The problem is that the calculated fields are no long working on the page
footer.
Is there any way to have this calculated fields working on the page footer?
...
|
5 |
22.09.2006 17:59:01 |
|
|
Passing data from a form to report field
I made a form that passes data from a popup to the report so I don't have to
make duplicate pages.
The form name is "Chooser"
The variable name is "Type"
If I hard code the value from the form like this it works fine:
=Sum(IIf([Product Type]="Soccer",[Volume],Null))
But when I pass the variable it doesn't. (I'm sure I'm just missing a
bracket or something)
=Sum(IIf([Product Ty...
|
5 |
22.09.2006 16:43:03 |
|
|
Can the header grow?
How can I set the page header to grow, the format section in the properties
box does not have that option as it does in the detail section.
I have a field in the page header which can grow, but when it does it pushes
some of the other fields in the header out of the print area. ...
|
2 |
22.09.2006 16:23:22 |
|
|
message: Zoom not available now.
I have tried using 'acCmdZoom75' suggested in another post and it doesn't work.
Anyone else come across this?...
|
6 |
22.09.2006 16:09:36 |
|
|
Display last entry in in field footer.
Hi, I have a report that is on loan status. In the detail I have the
fields Loan#, Date, Amount, LoanName, City, State, Analyst, and Notes.
I have set up grouping by loan number and I will only display the group
footer in the report with all the same fields. I have a sum of [Amount]
to get the current balance and I want to display the last note that was
put on the account with text in it. For...
|
3 |
22.09.2006 15:41:13 |
|
|
bar chart problem
How do I widen the bars of a bar chart in Access. They are very narrow. The
X-axis are dates. How can I make the chart look more asthetic?
cheers!...
|
1 |
22.09.2006 15:37:02 |
|
|
switchboard connection problem
I have an Access database which opens on all but 2 computers. These 2 will
not open the switchboard which was designed using the Access switchboard
manager. Everything else is fine, it just won't run the swithboard.
The error message is :
Runtime error-'2147220999(80040f9):Method ' Connection' of object_current
project failed.
The VB code which highlights as the place it fell over i...
|
1 |
22.09.2006 15:34:01 |
|
|
Telling the printer that report is envelope
When using Access Reports to print an envelope is it possible to generically
tell the printer that the document is an envelope? I want to tell whatever
printer is being used that it should use its envelope tray or send a mesage
asking for a manually fed envelope. The person I am working for seems to
think that this is possible, but I cannot figure out how. Thanks for any
suggestions....
|
1 |
22.09.2006 15:27:01 |
|
|
Word document in Header
I created an Access report but I need it to be preceded by 10 pages of a Word
document. When I try to link it or cut/paste it or whatever, I just get part
of the first page. Since I need to print it as a booklet, I can't simply
print them separately. Any suggestions?
Thanks,
Enid...
|
1 |
22.09.2006 15:26:02 |
|
|
Control Source syntax
I have a field declared currency decimal value 2 places.
I need the field to produce the following value so that I don't have 4
digits after the decimal:
Int([SumOfRentTax]*100+0.5)/100
I get #Error in the field when I try to run the report.
What is the proper syntax?
I have tried:
=Int([SumOfRentTax]*100+0.5)/100
and
=Int([SumOfRentTax]*100+0.5)/"100"
and
Int([SumOfRentTax]*1...
|
5 |
22.09.2006 14:54:02 |
|
|
How can I convert Text to Numbers for a Report?
I would like to be able to convert Numbers that are stored in a Text Field in
my Table to Numbers to be calculated on a Report. Any possible way?...
|
3 |
22.09.2006 13:46:02 |
|
|
detail section row height
I need to generate a report which will be 9 pages long but the detail section
runs out after 55.873cm.
Is it possible to alter the default height for the detail section please....
|
5 |
22.09.2006 13:33:03 |
|
|
A0L Keyword Search Data Report & Frequency Count
I have downloaded the AOL search data that was posted by mistake, and
want to create a report that shows the "Query & Count or Frequency
sorted high to low. I'm using
MS ACCESS 2000.
Thanks,
Rob
Example Output
+----------------------+---------+
| Query | Freq |
+----------------------+---------+
| google | 332192 |
| ebay | 139207 |
| yahoo | 130538 |
| yahoo.com | 97518 |
...
|
1 |
22.09.2006 13:13:43 |
|
|
If null in textbox
Hello all, quick question I hope. I have a field on a report called
availcredit that is somtimes null and sometimes it has a number. I am trying
to make a new text box that uses availcredit in some calculations. Here is
what I have so far, I know that its totally wrong.
=IIf([avilcredit],IIf([avilcredit]=Null,[CurAvailCreditAmt]+[curprinbal]-[SoldExposureAmt]),([CurAvailCreditAmt]+[curprin...
|
4 |
22.09.2006 10:42:20 |
|
|
Lebans Rotate Text function fRotextEMF
Hi
Can anyone advise me what the problem is here please.
Have downloaded Steven Lebans Rotate text demo and have tried to use the
above function on one of my reports. What is happening is that whilst the
image control is being added to the report no text, as per the initial label
selected, is shown.
Using Access 2002
TIA
Tom
...
|
7 |
22.09.2006 08:02:00 |
|
|
Do not display both sections of group header in a report
Hello,
Hopefully this is not too novice a question for everyone, but it has me
stumped. How do I not make visible the first section of a group header in a
report while keeping the other section of the group header visible?
Right now I have a report that has delivered (value =1) vs non-delivered
(value=0) patients seen. All the patients must be listed in the report and
sorted by non deli...
|
2 |
22.09.2006 04:45:36 |
|
|
Filter repeat in report
Hi all
I am using the list box in the form to filter the query and then view
the report.
Problem is when I get report for one time say for locationName = "ABC"
and closes the report.When I select next time LocationName = "XYZ" and
click button to open report.then i get records inreport for both "ABC"
and "XYZ".
Actually the filter in the report does not clear it self and keep
adding th...
|
5 |
22.09.2006 02:00:39 |
|
|
Conditional Formatting....
Hi all..
I did a search, but I didn't quite find what I was looking for. What I am
looking to do is this.
I have a form that I use that allows the user to enter say a lic plate
number. Then based on the lic plate number a report is generated that has
that lic plate number.
But what I would like it to do is bold the selected plate number because
some entries have say 7 or 8 plate n...
|
2 |
22.09.2006 01:01:58 |
|
|
How to print invoice with partial delivery?
I have an invoice report generated from my order entry screen. The order
entry screen has order IDs allowing me to do partial invoicing.
My question is how do I print one invoice for ALL Order IDs for that
particular order? For example:
Customer orders 1 widget, 11 things, and 8 jigs. We ship and invoice this
order in 3 partial invoices. Now the customer wants a combined invoice (1...
|
1 |
22.09.2006 00:58:12 |
|
|
Auto Update
I have a report that uses a query as the data source. As the data changes in
the database, the report does not show the updated info when I bring it up.
Is this normal?...
|
4 |
22.09.2006 00:03:40 |
|
|
Multiple records per report page in Access
I am trying to create a report which lists 3 contacts (per page) and their
subsequent information (ie: location, product they have, month/year sold) in
the Detail section (of the Design view). I have labels alongside data fields
pulled from the main table. Once I laid out the formatting then I copied and
pasted all cells twice. But now it shows 3 of the same record per page
instead of t...
|
5 |
21.09.2006 22:18:03 |
|
|
Lebans' Examples
Ok, Here is a really stupid question...I have copied Lebans' Zip file
"PrintLinesClass2K.ZIP" to my PC, extracted it, and opened up the database
contained within the Zip file. Now what?
I want one border around my report, around the header, the detail, and the
footer.
In the zip file there are two BAS files, three CLS files, and one mdb file.
I am guessing I need to copy somethin...
|
4 |
21.09.2006 21:43:14 |