Thread: [Solved] Multiple queries on table
View Single Post
 
Old 09-16-2012, 04:14 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi jillapass,

Perhaps a simple COUNTIF against the main list for each booking will do. If the count is greater than 1, that indicates a prior booking.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote