Beginner Question on Simple Report

[Dana DeLouis]

Hello. I was wondering if anyone could please help with this beginner
question.
Using: Access 2003 with Windows Xp.

I have a simple table with Name, and two Memo fields.
What I would like is a very simple report with all Memo1 data, followed by
Memo2 data.

All the wizards are putting Memo1 and Memo2 side-by-side.

What I've been trying is to make 2 Queries. Qry1 is just Memo1, and Qry2 is
just Memo2.

Here's where I'm stuck. What would be the best way to make a simple report
with Qry1 listed first, followed by Qry2.

I don't need fancy formatting, page numbers, etc because I eventually need
to export this report as a text file.

Thank you very much in advance. I've been stuck on this for a long time.

Looking forward to learning Access.
Thanks.

Dana
Windows XP & Office 2003

 

[Rick B]

I would simply use one query with the three fields.

Then, In the report, I'd open the field list and drag the NAME field to my
detail section, then under it, I'd drag MEMO1, then under that I'd drag
MEMO2. Id make each control as wide as the page and only a few pixels tall.
I'd set the "can grow" property for each field to "true".

That's pretty much it.

 

[Dana DeLouis]

Thank you Rick for your time.
When I do that, I get
Memo1 A, followed by Memo2 A,
Then
Memo1 B, Memo2 B,
etc

Basically, it is still showing each record.
What I really want is to list all of the Memo1's first, then all of Memo2's
next.

I saw a thread on Sub-Reports. Maybe I have to have 2 reports within 1
report.
First report with just Memo1's, and a second report with just Memo2's.
I just tried it via the Subform / SubReport button. It looks promising, but
it is confusing.
I'm having a hard time editing it.
I was hoping for a simple dray n drop of both queries, but I guess that's
not possible.
Ahh. It's so confusing when one is new.
I'll keep trying this sub-report thing to see if it's what I need.

 

[Rick B]

Okay, maybe I misunderstand your table. Give me an example of your records.
You have a name, then two memo fields. It seems to me you'd want this:


John
Memo1
Memo2

Bill
Memo1
Memo2

Susan
Memo1
Memo2

etc.

 

[Rick B]

Okay, I reread your first post.

If you want this....


John
Memo1

Bill
Memo1

Susan
Memo1

John
Memo2

Bill
Memo2

Susan
Memo2


I would guess that you would want to create two separate reports, one with
each of the queries you built and then insert those as subreports. The
first report (and query) would pull the Name and memo1 only. The second
report (and query) would pull the name and memo2 only.

Hope that helps. Sorry for the confusion.

 

[Dana DeLouis]

Hi Rick. Thanks again for your time. I think I've got a solution.
What I was looking for was:
John's Memo1
Bill's Memo1
Paul's Memo1

Then ...
John's Memo2
Bill's Memo2
Paul's Memo2

I just noticed the default file format is set for Access 2000. I changed
the default file format to Access 2002-2003. I am now able to drag both
queries to a blank report. Apparently, it now automatically makes a
"subreport."
I'm too new to know if changing the default format made the difference, but
it now works.
I think I can take it from here.
Thanks again for your time. :>)