datareport urgent help

[engnouna]

Hi
I want to generate a report Based on the following query

SQL = "SELECT * from test inner Join Client on test.ClientID=Client.ClientID"
SQL = SQL & " inner Join Event on test.EventID=Event.EventID inner Join Duration on test.IntID=Int.DurationID"
SQL = SQL & " INNER JOIN Room on test.RoomID=Satellite.RoomID inner join Guest on test.GuestID=Guest.GuestID where BID=4"

I will be using the Data report present in VB6(my database is Access)
in My Report I want to display the Following Fields:
Client
Event
Duration
Room
Guest...

How can I do it?

thanks

[Hack]

Moved to Reporting section