We help IT Professionals succeed at work.

ROOM MASTER - Accomodation softwear

kingjely
kingjely used Ask the Experts™
on
Hi Guys our resort uses ROOMMASTER Accom softwear.
Under the reservations tab, there is 'Quck reports'

I want a quick report that shows only duplicate bookings.
In sql somethiung like this;

select name, surname, confirmation number, count(*)
from Reservations
group by name, surname, confirmation number
having count(*) > 1

Any Idea how to do this is quick reports>Roommaster.
I try the above and get a BIND error ?

Thankyou
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,
The query given by you looks ok (except that there is a space in the "confirmation number" field).

Can you try running the query without count(*) in the select. Something like below:
select name, surname, [confirmation number] 
from Reservations
group by name, surname, [confirmation number]
having count(*) > 1

Open in new window

You may also try to get the exact column name by writing a query like:
select top 10 * from Reservations

Open in new window