Hi,
I have created a report from 2 tables:
Menu (MealName, MealCost)
Meal Bookings (MealName, MealQty, BookingDate)
The report is supposed to show all the meals and the amount of times they have been booked. between a specified date range.
Therefore i want it to show the all the meals on the menu even if some of them have not been booked.
At present the report only shows the meals that have been booked. How can i change this to show even those that havnt been booked.
I Tried changing the linking option to do a Right outer join on: MealBooking.BookingNO = Menu.BookingNo
but this did not work. does anyone know what im doin wrong?
A second question i have is how i display a default message when the results of the record selection does not return any data???
Any help is appreciated
I have created a report from 2 tables:
Menu (MealName, MealCost)
Meal Bookings (MealName, MealQty, BookingDate)
The report is supposed to show all the meals and the amount of times they have been booked. between a specified date range.
Therefore i want it to show the all the meals on the menu even if some of them have not been booked.
At present the report only shows the meals that have been booked. How can i change this to show even those that havnt been booked.
I Tried changing the linking option to do a Right outer join on: MealBooking.BookingNO = Menu.BookingNo
but this did not work. does anyone know what im doin wrong?
A second question i have is how i display a default message when the results of the record selection does not return any data???
Any help is appreciated