Best way to check for customers who made a booking? 1

[47redlands]

Hi I have a table called tblBooking with following fields
performance (data type number) primary key
Seatnumber (data type text) primary key
status (data type text) primary key
Ticketprinted (data type yes/no)

status at the start is all filled in with "FREE" when a customer makes a booking the customer primary key is entered so thus "FREE" becomes ALA025.

I have created a querry called qryTicketDetails using fields from tblCustomer, tblPerformance and tblSeat.

In qryTicketDetails I want check for customers that has made a booking what is the best way to do this?

 

[PHV]

What is the actual SQL code of qryTicketDetails ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[47redlands]

Hello PHV,

I learnt SQL many years ago when I was doing some Oracle work and haven't used it for a long time. With Access I generally create everything using the wizards, controls and other features. I created qryTickets using Access wizard.

Anyway I was able to solve it by entering a very simple code in the criteria row of qryTickets.

Thank you