HELP PLZ... (complicated query)

[marco_pb via AccessMonster.com]

I have table A (courseA, note1), Query B(id, courseB, begin, end) PK: courseA
and id

sample data:
courseA: a - b - c id : 1 - 2
note1 : x - y - z courseB: a/b - c
begin : 12.feb.00 - 1.jan.00
end : 20.feb.00 - 18.jan.00

the problem is, I want to create report based on courseA, but I need begin
and end date from B.begin and B.end(as you can see the courseB is combination
of 1 or more than 1 courseA).
Should i make the query: courseA, begin, ende, note1? How?
I really need <our solutions..

thank you very much.. I don't know how to do this actually.. I am new in
using Access 97. thanks again

 

[KARL DEWEY]

I can not make heads or tails of your table structure. Post it something
like this --
CourseID - Autonumber - PK
Course - text
Note - memo
Begin - datetime
End - Datetime

Then post an example of the data like --
CourseID Course Note Begin End
1001 Brown's Betty Nothing to add. 1/21/05 3/31/05
1002 John's Turnip Nothing to add. 11/21/05 12/31/05

And last post an example of what you want the resulting data of the query to
be - not a report layout.

 

[marco_pb via AccessMonster.com]

thanks...

I have alrady got the solution for this one.
I Really thank you for replying my post so soon. thank you