|
Parameter Query and reports
I have a parameter query that I run to pull certain dates (ie - 3/1/08 -
3/31/08) and the name of the event that happened in that date range. The end
result that I want to get is a report that lists these dates (which is easy)
and also same events for the prior month and prior year.
I have tried to create a 2nd query that will pull the event name from the
parameter query, but I am st...
|
4 |
12/2/2008 5:15:02 AM |
|
|
Microsoft MVP Donald Belcham to Speak on Visual Studio, C# vNext, Aspect Oriented Programming, Live Mesh
Microsoft MVP Donald Belcham to Speak on Visual Studio, C# vNext,
Aspect Oriented Programming, Live Mesh
Bangalore, December 1, 2008: When writing Microsoft technology-related
applications to have strong separations of concerns you inevitably run
across some items that, while appearing as separate concerns, do not
behave in the same manner as the other concerns. Instead of
interacting only...
|
1 |
12/2/2008 5:12:07 AM |
|
|
Some report lines showing up bold in adobe acrobat pro
I have created a dashed line in my report. Some of my lines when I
view it in adobe acrobat pro are bold. Is there a fix for this?
Thanks,
Kathy
...
|
1 |
12/2/2008 12:10:35 AM |
|
|
alter some printer settings on several different reports
I have a report MDB that uses an ODBC database to do its reports from.
I have gotten a request from one of the users to change the default
settings for a printer. Because of how our network is set it the
printer settings for each of the printers get reset after a document
is closed the only thing that can be set is the default printer.
What I need to do is 3 fold.
The users that need ...
|
1 |
12/1/2008 10:08:08 PM |
|
|
New to Chart/Report - Cant make it work
I created a nice little Query that totals up all my data.
Problem is, I can't seem to get the Chart-Builder to make this for me
correctly.
Here's what my Query returns:
CategoryID R1 R2 R3 R4 R5 R6 AVG
1 91 91 82 82 82 82 86
2 75 75 75 75 75 75 75
3 100 100 100 100
4 ...
|
2 |
12/1/2008 7:51:01 PM |
|
|
Creating a historical report
I need to create a report that reports history based on a 'Date Completed'.
So I created a query off of my table that calculates 30 days less that the
'Date Completed'.
Using an [Enter Completed Date] in my query as 09/30/08 the result in my
'Date_Completed30' field is correct, indicating 08/31/08.
Now I want a report that will give me all the records between the
'Date_Completed' an...
|
6 |
12/1/2008 6:25:01 PM |
|
|
Report consisting of multiple subreports
I 've build a dosen of reports (in shape of tables and charts) summing the
data from different angles. Every report shows gross numbers for all the
clients combined.
Now I want to nest all the reports in one principal report, wich is destined
to be opened from form by selecting cboClientName (ClientID value) and
pressing control button. The report, thus, will be filtered (as all of its
...
|
1 |
12/1/2008 4:48:01 PM |
|
|
Grouping w/ Graphs in Rpts
I’ll explain the problem as best as I can.
I have a report based on a query. The query contains the following data:
Company_Name (Demo, Inc.)
MonthDate (01/2008)
ItemDescr (Copy and Printing)
Expected (125,000)
Actual (120,000)
The report is grouped by Company_Name, then ItemDescr, then sorted by
MonthDate. It runs great. Looks like this.
---------
Demo, Inc.
Copy and...
|
12 |
12/1/2008 3:32:01 PM |
|
|
Add a field from a query after the report is once created.
I am trying to add a field from a query which I created after the report was
created. There definitely must be a way out. ...
|
3 |
12/1/2008 12:28:14 PM |
|
|
How do I insert a new column
I have created a report and I need to insert a new column at the beginning of
my report. How do I do it?
Many thanks,
New to Access...
|
2 |
12/1/2008 11:46:47 AM |
|
|
How do I create grouping intervals
I am new to acces and working on a report. How do I create grouping
intervals in one of my columns? Any help would be greatly appreciated.
Thanks again,...
|
2 |
12/1/2008 2:06:08 AM |
|
|
Numbering
Hello,
I have a report with multiple records in it. I have already grouped the
report by full_name and forced a new page after this section. What I would
like to do is print the entire report, which can be 300 pages, with the
number of pages to reflect only the pages of that record. Right now I'm using
="Page " & [Page] & " of " & [Pages] so the page numbers will say for
example 1 of...
|
8 |
12/1/2008 1:21:42 AM |
|
|
fields are not printed
Hi, I have this strange problem...
In my pageheader I have 2 independant textfields together with some
other fields
The 2 textfields aren't printed....
They both are visible = true
I created a "edge-style" of 3 pnts... none is printed, not even the
rectangle around them
The other fields in the report heading are rpinted correctly
What can cause this?
Thanks...
|
2 |
11/30/2008 11:41:33 PM |
|
|
Multiple IFF Statements help
I need to get this to work:
=IIf(Forms.[Helpgate Menu].replist is null And Forms.[Helpgate Menu].Mgrlist
Is Null,"Questions - All Reps"),iff(Forms.[Helpgate Menu].Mgrlist Is not Null
and Forms.[Helpgate Menu].Replist is null,"Questions - Per
MGR"),iif(Forms.[Helpgate Menu].replist Is not Null and Forms.[Helpgate
Menu].Mgrlist is null,"Questions - Per Rep")
Thanks in advance ^_^...
|
4 |
11/30/2008 2:06:12 PM |
|
|
detail line with zeros - suppress printing?
I have a report with detail lines with
Name Col1 Col2 Col3 Col4 Col5 Col6 Col7
The Col's are numeric fields. I do not want to print the detail line if ALL
the Cols fields for that detail line have values that are zeros or nulls.
How would you do that?
Thanks,
Susan
...
|
9 |
11/30/2008 8:15:26 AM |
|
|
ID Label Printing
I am trying to do ID labels - 2 across and down. I am not doing very well
in the sizing of the lables. Is a report th best way to do this?...
|
2 |
11/30/2008 1:02:05 AM |
|
|
Yet_another_“blank_pageâ€_issue
I have a report with a grouping that may optionally be set to page break on
change. When I change the Group Footer’s ForceNew property from 0 to 2 in
the Open Event to get the page break, I always get a blank page at the end of
the report.
I thought this would be easy… what am I missing?
---
terri...
|
8 |
11/29/2008 11:51:47 PM |
|
|
detail line question
Is there a way with expressions to control whether an individual detail line
shows or not in a report? I am not referring to suppressing all detail
lines in a report.
...
|
3 |
11/29/2008 8:45:57 PM |
|
|
Count or DCount used in a report
In my underlying query I have field called "Employee" that has either CAT or
Volt as the data that input.
This is how my report looks
Shift Header
Supervisor Header
Area Header
Employee Header
Area Header
Current Job Header
Detail
Employee Footer
Area Footer
...
|
2 |
11/29/2008 3:27:00 PM |
|
|
Link chart to report
I've created bar-chart showing payments in different currencies (variable
quantity) grouped by year and destined to be filtered by ClientID value. The
query-code under the chart is:
TRANSFORM Sum([qryPayments].PaymentValue) AS SumOfPaymentValue
SELECT (Format([PaymentDate],"YYYY")) AS Year
FROM [qryPayments]
GROUP BY (Format([PaymentDate],"YYYY")), [qryPayments].ClientID
PIVOT [qryPayme...
|
5 |
11/29/2008 11:04:12 AM |
|
|
Display Current Month
How to display the "Current Month" in a report header in an unbound text box
inAccess 2003?...
|
3 |
11/29/2008 5:46:01 AM |
|
|
Set Report Values to Table
I have an Access 2003 report that has multiple calculated values.
Now I need to use of those values in a subform. Is there a technique in
Access similar to SetValue so a
calculated report value can be transferred to a table field?
...
|
2 |
11/29/2008 3:27:01 AM |
|
|
Report delay message
I have few reports that take from 30-60 seconds before they open up due to
have query calculations. What is the best way to I have a message such as
“Please wait while the report is generate.†be displayed and then disappear
once the report opens up?
Thanks,
Silvio...
|
2 |
11/28/2008 11:07:37 PM |
|
|
When using VLookup, how do I replace #/N/A by "0"?
...
|
2 |
11/28/2008 10:12:11 PM |
|
|
How do I set up a conditional page break in an Access report?
I am setting up a dealer report in Access where each dealer can have a
different number of detail rows on each page. But I can't find out how to
print one page per dealer rather than several pages, each containing one row
for the same dealer. How do I do this?...
|
2 |
11/28/2008 4:06:01 PM |