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
