So I have a report which pulls data from a table (tblreservations) via a query.
The value for the field "Reservation Source" is a number on this table.
There is another table (tblResorigin) which lists the alphanumeric value of "ReservationSource, for example "1 = Expedia, 2 = Booking, 3 = Bookiply,...."
When this report is created, the value that shows up in the field is naturally a number (1, 2, 3,...) but I would like it to be the value in tblResorigin instead; Expedia, or Booking, or...
Can that be done?
thanks
mafhobb
Code:
SELECT tblReservations.ID, tblReservations.PropertyName, tblReservations.GuestName, tblReservations.CheckInDate, tblReservations.CheckOutDate, tblReservations.CleaningComments, tblReservations.Status, tblReservations.PhoneNumber, tblReservations.CheckInContacted, tblReservations.CheckInReady, tblReservations.CheckInTime, tblReservations.ReservationSource FROM tblReservations WHERE (((tblReservations.CheckInDate)=Date()) AND ((tblReservations.Status)="Active"));
There is another table (tblResorigin) which lists the alphanumeric value of "ReservationSource, for example "1 = Expedia, 2 = Booking, 3 = Bookiply,...."
When this report is created, the value that shows up in the field is naturally a number (1, 2, 3,...) but I would like it to be the value in tblResorigin instead; Expedia, or Booking, or...
Can that be done?
thanks
mafhobb