I'm programming a booking system for a singer as a school project (beginner, very limited knowledge). The table 'booking' includes fields showing expenses incurred for the singer's gigs. The field names are 'expense incurred 1', 'expense incurred 2', & 'expense incurred 3'. These fields are linked to the 'expense' table via lookup wizard, which contains expense names e.g. petrol, food, drink, and expense costs for each e.g. petrol would be '£20.00', food '£10.00', and none '£0.00' etc.
I was wondering how it would be possible via a query, to have just one 'expenses' field in the 'booking' table - i suppose this would involve bringing all three values entered and the costs of these added together to get all expenses incurred listed in the same field i.e. 'food, drink, petrol', and the field next to it having totalled the expenses i.e. '£40.00'.
I was wondering how it would be possible via a query, to have just one 'expenses' field in the 'booking' table - i suppose this would involve bringing all three values entered and the costs of these added together to get all expenses incurred listed in the same field i.e. 'food, drink, petrol', and the field next to it having totalled the expenses i.e. '£40.00'.
