Urgent Please Help!!!!!!

[smash81]

Hello,
I am trying to create a report but have come to a place and got stuck.Experts please help out.
My tables are as follows:

Park
----
park_no
park_name
Rate
Tickets_available

safari
------
safari_no
other safari details

safari_tickets
-------------
safari_no
park_no
rate (the rate at which the tickets are given may be different from
the rate stored in the park table.Thats why this field appears
here)
qty_used

Now i want my report to give me the details of each safari and the amount (rate*qty_used) for each park.

for example
safari_no date Goodpark Badpark thispark thatpark - ------- --- ------- ------ ------ ------
1 15/02/99 150 200 2000 0
2 18/02/99 0 120 200 0

I am able to get the park details but have problems displaying the amounts spent for each park.Please help me on how i can filter out the records per park.I tried using a formula but could not filter out the details park wise.Please help me.
Thanks

 

[LeonelSanchezJr]

What kinds of tables are these? SQL?

What exactly do the follwing columns mean and how do you calculate these numbers: goodpark, badpark, thispark, thatpark?

How and where are you writing the query for this report?