counting
Sun, 2 Nov 2008 16:45:25 -0800
How do I count in the report header the number of times a field is 'true'
as opposed to 'false' ... ? TIA
--
____________________________________
In Christ's matchless name
ted n6trf
...
|
Change printing orientation with in an access report
Sun, 2 Nov 2008 17:31:01 -0800
I am creating a report in access and the first page will need to print in
portrait and the second page needs to print in landscape.
The first page is a letter and the second page is information that cannot
fit in portrait layout.
Example
Page 1 (Print Portrait)
Dr. John
Please review records below.
...
|
SubReportTwoColBalanced DB by A.D. Tejpal
Mon, 03 Nov 2008 00:05:48 GMT
Has anyone use this sample DB with success in converting the subreport to
view Down and Across? I played around with it but I have no clue in what I am
doing. Any response will be greatly appreciate.
Kbrad32
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-report ...
|
If my report is not listed as a Class Object is my db corrupt?
Sun, 2 Nov 2008 14:46:01 -0800
Here's what I am trying to do - I have a report that I'd like to be able to
run based on a low and high date range. I enter the two dates on my form
into text boxes. I was able to filter two other reports this way in the
command button that opens the report (Report_Blahblah.Filter = "[Complete By]
>= #" & ...
|
WHERECondition in a report.
Sun, 2 Nov 2008 13:14:08 -0800
Is it possible to retreive the "WHERECondition" that is set in OpenReport()
command? Is so, how do I do this? I want to retrieve this on the report
OnOpen() event.
Thanks
...
|
Pagenate by Alphabet
Sun, 2 Nov 2008 11:53:05 -0800
How do I get a report that is pagenated by alphabet? In otherwords, I need
a report that seperates the A's from the B's and so forth.
...
|
Report is Blank!
Sun, 2 Nov 2008 10:39:01 -0800
I need help with a report. Here is what the SQL looks like:
TRANSFORM Count(MRPC_Query.Reason_Code) AS CountOfReason_Code
SELECT MRPC_Query.MRPC
FROM MRPC_Query
GROUP BY MRPC_Query.MRPC
PIVOT MRPC_Query.Reason_Code;
The idea is to have the user input a beginning and end date into a form,
then click the ...
|
|
|
auto size label
Sun, 2 Nov 2008 06:54:52 -0800 (PST)
I have a report needs to support 2 languages
since 2 languages has different length.
I am looking for the property of canShrink or canGrow or autoFit to
have the label size to fit 2 languages.
Are there any propery or method for this? if not, are there any
workaround?
Your information is great appreciate ...
|
Subreport with no records
Sun, 02 Nov 2008 01:17:38 -0800
I have a main report whose role in life is to contain 3 subreports and
display totals for each of these subreports and grand totals summing all
3. There are page break controls forcing page breaks between each subreport.
So, the structure is something like this:
MAIN REPORT
Main Report Header
Subtotal fo ...
|
ACC2000 'query date' issue
Sat, 1 Nov 2008 17:54:01 -0700
My database has a date table with 'manually keyed' weekly date ranges (1
record/row in the table per week/date range) that show as combo box drop-down
lists in several of my forms.
I'm trying to create a report so that when you open the report, it offers
that same combo box drop-down list to users so they ...
|
