RE: Still have hope but need more help. First Question, more to fo

Tech-Archive recommends: Fix windows errors by optimizing your registry

Good afternoon Duane,

Yes, they are.

When I tried to combine my SumQry_MonthIncome with my SumQry_MonthExpenses,
up in the right hand corner appears a tag which says "Union Query." But, when
I enter the field names , I receive multiple returns of the entries. Does
that mean that I am ready to develop some sub-reports? Boy, oh boy, do I hope
so; otherwise I'm going to be doing some cutting and pasting at the copy
machine tonight or I'm going to enter my information quickly into Excel.

What do you think I'll be doing? k

"Duane Hookom" wrote:

Aren't your "groups" just different records from the same table/query?

Subreports are much like subforms. They are just reports that are placed on
other reports.

--
Duane Hookom
Microsoft Access MVP


"znibk" wrote:

Good morning Duane,

Sorry to take so long getting back.

Your first paragraph is right on--correct; the number of records in each
group varies. The good news is, I hope, is I have already put the information
in a query and am using that query as the Control Source for the report. In
the report, I have put the information for each column in the Detail section.
For the left side of the report, I have [CC] [ACD] for the right side of the
report, also in the Detail section, I have [IKC] [Donation] [IKValue]. All
information is there except for the fact it list all the information for the
Cash Contributors before it lists all the information for the In-kind
Contributors. I need the columns to be side by side !! equally regardless if
one column has more data than the other.

And, unfortunately, you have completely lost me on the second paragraph;
except to put them in a query. I have browsed everywhere I can think of to
find out how to create a sub-report, how to create a union query, and how to
create a report that pulls information from more than one query (where
information in those queries is necessary for the report, and everything
needs to be in side by side columns (a monthly financial report for two
banks) without the use of code. I am mentioning that, because I was hoping to
be able to have a sub-report under my nice neat side by side columns which
will show the amount of cash contributions and store sales I have received
for the last 12 months.

I know all this can be done. I know it can be done in Access better than in
Excel or Word, what I've used. I just need help in obtaining the wisdom of
how. I have the determination and patience, and am willing to help others
learn what I know. I hope you have those qualities and can help me out. k


"Duane Hookom" wrote:

Apparently you have groups of records that you want appear together in
columns even though the number of records in each group might vary.

I would change the record source of the main report to a query of just
unique "group" values. Keep the columns. Then create a single column
subreport that can be place in the detail section of the main report. Set the
Link Master/Child properties to the "group" field.

--
Duane Hookom
Microsoft Access MVP


"znibk" wrote:

I have a report and I would like the information to print side by side on the
report page ! ! (columns which are even at the top) not !
!
(Columns where all the information for one group is printed before the
information from the next group is printed. Is there anyone out there who can
help me out? I really hope so becauxe I need to complete all reports by
tomorrow (8/13) and have used many of the suggestions I've received from you
all, but I am still struggling with some things. the above is one of them.

The next is how to et everything together in an Access report wich looks
like a financioal ***. I will need to combine several queries and am having
a problem with part of the results showing, then I'll add another field and
I'll receive no returns or i'll receive over 2,000. More spicifics on this
later. Right now, if someone could help me out with the side by side issue,
I'd really be greatful.
k
.

Quantcast