|
Conditional Format for first detail only
I would like to format my report so that the first detail in each grouping
has a "$" in front of it and the other details do not. Is there any way to
select only the first detail? If I could do that, I could probably then
concatenate the "$" in front of it.
...
|
5 |
21.09.2006 20:41:01 |
|
|
Help! Multiple sub-totals by group in report
I am trying to create a report that purely displays subtotals based on
different groups. I have a query of activities that includes fields in each
record of Region, Channel and Cost Type (there are more, but this should be
enough to illustrate). For instance:
QUERY
[Activity Name] ... [Region] [Channel] [Cost Type] [Cost]
Activity 1 ... Region A Channel C Cost Type B $1,...
|
3 |
21.09.2006 20:33:02 |
|
|
Two fields as One
I have a query with a lastname and firstname field. In my report, I want the
two fields to appear side by side as lastname, firstname. Regardless of the
lastname length, I want only a comma and one space between it and the
firstname. How can I do this?...
|
3 |
21.09.2006 19:46:57 |
|
|
Crosstab Report
Hi,
I am using MS ACCESS XP. I setup an crosstab query and want to create a
crosstab report but following the Help file instruction and just realized,
the report columns are fixed and not dynamic. Is there any solution that
will generate the crosstab dynamic column?
I was thinking about dumping the query data directly to an Excel
spreadsheet, if MS ACCESS report don't support dynamic co...
|
15 |
21.09.2006 19:31:02 |
|
|
sum by group
If I added an extra column in my report that is not in the original database,
that gives me a whole total for the week, (adding across and I was able to do
an =sum in the control box that gave me the correct answer), is there a way
to get a complete total at the end of my report even though this is a new
column? I keep getting an error.
Thanks,...
|
3 |
21.09.2006 19:24:02 |
|
|
Hide detail based Sub
Hi Groupies
The detail section of my report contains a subreport. If the subreport has
no data I do not want the sub or the detail to print. The Visible property
for both the detail and the sub is currently Yes, but I have added the
following code to the Parent Detail section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
docmd.Echo False
If Me!rsubHo...
|
3 |
21.09.2006 18:19:11 |
|
|
Enter Parameter Value - Trim
Our office has a shared database (which is accessed by four people). When
one of the users tries to open a report in the database (which is based on
several different tables), a dialog box opens "Enter Parameter Value", with
"Trim" just underneath. She is the only user who receives this message.
Does anyone have any idea why?
Thanks.
Brenda...
|
2 |
21.09.2006 17:42:08 |
|
|
Reference Fields in Print_Event Procedure
I have a report called "Print Order" that has as it's Record Source a table
called "Order". I don't want to print all of the fields in the table order
but I need to access all of them in the Print_Event procedure. Therefore my
question is how do I reference fields in the underlying table "Order" , if
they are not bound to controls on the report. Do I need to open a recordset
on the tab...
|
2 |
21.09.2006 17:14:52 |
|
|
Three formats for one report
I have constructed a Vendor database. At intervals we need to send
information requests to certain vendors (the Approved Vendors). These
requests are faxed, so I have constructed a report to be printed. I have
based the report on a query that includes only the Approved Vendors and
filters for a date range (or for vendors from whom information has already
been requested, but who have n...
|
5 |
21.09.2006 16:54:46 |
|
|
"#Num!" Error display as "-"?
You all are saving my butt today. My gratitutde goes out to everyone...
Essentially, the following code throws #Num! because the Control Source is
trying to divide "0/0."
How do I get it to display a "-" instead?
=(Count(IIf([Product Type]="Allied" And [Transition Complete
YN]=True,[Wholesaler ID],Null)))/(Count(IIf([Product
Type]="Allied",[Wholesaler ID],Null)))
-Adam...
|
2 |
21.09.2006 16:50:02 |
|
|
preview report always in portrait even page set up is in landscape
Hi,
I don't know why when I click on Preview in the Access, it always show
me in portrait, even I change the setup to landscape and save it... and
when I click on setup it said ladscape, but it's not true... because is
in portrait..
I don't know why, can someone help me???
Cheers!
Claudi
...
|
1 |
21.09.2006 16:37:25 |
|
|
preview report always in portrait even page set up is in landscape
Hi,
I don't know why when I click on Preview in the Access, it always show
me in portrait, even I change the setup to landscape and save it... and
when I click on setup it said ladscape, but it's not true... because is
in portrait..
I don't know why, can someone help me???
Cheers!
Claudi
...
|
1 |
21.09.2006 16:37:18 |
|
|
Reports in a report
I have several small reports that show up in a larger report. The smaller
reports are organized into three columns. I have each report placed two grid
spaces below the previous. The first column of reports looks fine. In the
second, some of the reports show up an inch or more below the previous, even
though they are only a couple spaces from each other. What can I do to fix
this?...
|
15 |
21.09.2006 16:34:02 |
|
|
Field Display Question
How do I add a "$" in front of the following field's result?
Control Source Code: =Sum(IIf([Project Type]="Soccer",[Payment for
Allocation],Null))
Thanks,
Adam...
|
3 |
21.09.2006 16:08:01 |
|
|
Who reckons charts are a pain to deal with?
I am trying to create a line chart in a report. The date is on the horizontal
access and I want the total number of hours on the vertical access. Each line
will be the total hours for each department on a weekly basis.
Two problems:
1) Each individual point is being represented by a "1" so the chart just
gives a straight horizontal line
2) How do I change the horizontal access to pr...
|
5 |
21.09.2006 15:22:23 |
|
|
Blank detail section
I have a report called Invoice.
This report should have an A4 sheet size. So, I am working only with page
header, footer and detail section.
When the detail section has only one record there is a blank space between
the detail and the footer section.
I would like to fill this blank space with the vertical lines, as in the
detail section. So, it will seem that detail section reach page foo...
|
3 |
21.09.2006 15:15:02 |
|
|
conditional sum
I have an order’s report.
The detail section has the item movements.
Every item is either type A or type B.
At the report footer I would like to have an item movement summary by type.
This is, I would like to sum the quantities on the detail section for type A
and for type B. Something like:
Type A - X
Type B - Y
Can anyone give me and idea of which function should I use?
Many th...
|
2 |
21.09.2006 15:06:23 |
|
|
Aligning Controls On A Report
I'm writing a report that uses the "OnFormat" event to change the
back/fore color of certain labels and text boxes dependent on data.
I'm working in Centimetres and set the grid to 10x10 as recommneded,
but controls refuse to precisely line up. They look fine on screen,
but when you check their heights, one will be 0.501cm and one next to
it, the looks exactly the same, is 0.0503cm high.
...
|
4 |
21.09.2006 14:35:31 |
|
|
Background Image
I have a report that I need to print as a subreport. The report has a
background image which I like because I can then just simply overlay the
fields on top of the image and if the image needs updated it's real easy.
Unfortunately it appears that background images do not print on sub reports.
es anybody know of a way to get a background image to print on a sub report?
...
|
1 |
21.09.2006 14:16:22 |
|
|
Prevent Printing from Print Preview.
I need a way to allow users to preview a report but not be able to print the
report. I had hoped to just remove the toolbars and menus and then capture
all keystrokes and prevent things like CTRL-P. It does not look like I can
capture the keystrokes.
Any ideas how to do this? It seems like something a lot of people would
need. I know they could still do a print screen but I just re...
|
1 |
21.09.2006 14:13:24 |
|
|
Only sum if have more then one detail
Hi. I'm building a report and i've got a group and a footer for that group.
On that footer group I sum a column that appears in detais. Sometimes the
detais group only have one recordset. On those cases I don't want that the
group footer to appear.
regards,
Marco...
|
3 |
21.09.2006 14:13:01 |
|
|
Subreport duplicates in main report
I have created a simple main report that only consist of LastName, family
code. I then added a multiple column subreport which only shows FirstName.
There is a record for each student. Some of the students will have siblings
going to the same school. So that means that they to have a record. The
family code helps us sort them together. So one whole family may have upto 4
records if ...
|
5 |
21.09.2006 14:06:02 |
|
|
Shrinking detail (Controls and labels)
Here is the deal with my report. I have two controls in the detail
section [Notes] and [Date]. I also have the label for Notes sitting
right next to it so my detail section looks like this.
Notes [Notes] [Date]
Sometimes for a transaction there are no notes and in that case I want
to hide and shrink the detail and skip to the next note. Right now I
can hide the detail section but i...
|
3 |
21.09.2006 13:51:35 |
|
|
Entire Text Not showing.
Hi,
I have a comment field. Originally the property in the table was set to
text with 255 character limit. A comment was typed in but was truncated. I
changed the field propery to memo. I deleted the text and re-typed the
comment. All the text went in. On the report I sed the control to Can Grow
and Can Shrink. More of the text prints out but it gets cut off too. The
funny thing is...
|
3 |
21.09.2006 13:15:11 |
|
|
can't print in landscape
Hi,
I design a report in access and I put in the setup page as landscape..
then I use VB to print out the report..
The problem is I don't know why, it keeps printing in portrait and in 2
pages, instead of landscape...
Can I force to print in landscape? I try this line of code
Printer.Orientation = vbPRORLandscape but it doesn't work...
here's part of the code that I used in VB to prin...
|
3 |
21.09.2006 11:01:57 |