Kevin Cheesman Posted May 22, 2009 Share Posted May 22, 2009 I have a bookings table that has active and cancelled booking. Cancelled booking are shown by a date in a 'booking cancelled' field. I'm using a relationship to join a table of incremental dates to give me a display of booked a free date, which works well but I can't seem to hide the cancelled bookings. I need to keep them in the table in case of any query. What's the best way to remove these records? TIA Link to comment Share on other sites More sharing options...
comment Posted May 22, 2009 Share Posted May 22, 2009 You could define a calculation field = Case ( not BookingCancelled ; BookingDate ) and use it in the relationship instead of BookingDate. Link to comment Share on other sites More sharing options...
Kevin Cheesman Posted May 22, 2009 Author Share Posted May 22, 2009 Nice one! Thanks for that. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5452 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now