- Messages
- 18
- Reaction score
- 12
- Points
- 13
You are going to prepare a report showing the details of bookings where there is a flight into or out of
London during the month of August 2010.
11 Select from all the records only the HolRef, Forename, Surname, Address, Town,
Postcode, Resort, Type, Hotel, Cost, Paid and the To, From, Date and Flight fields
from both the Out and Home tables for the flights either out of or into London during the
month of August 2010.
12 Add a new field called Balance to this extract that is calculated at run time. This works
out the Cost of the holiday minus the deposit Paid for each of these holidays. Use an
appropriate format for this field.
plz post worked solution for these questions.
thanks in advance
saif
London during the month of August 2010.
11 Select from all the records only the HolRef, Forename, Surname, Address, Town,
Postcode, Resort, Type, Hotel, Cost, Paid and the To, From, Date and Flight fields
from both the Out and Home tables for the flights either out of or into London during the
month of August 2010.
12 Add a new field called Balance to this extract that is calculated at run time. This works
out the Cost of the holiday minus the deposit Paid for each of these holidays. Use an
appropriate format for this field.
plz post worked solution for these questions.
thanks in advance
saif