You aren't wrong. Commerical solicitatation is not welcome in these groups.

Steve, the poster making the offer, has been told many times by many people
that his solicitations in these newsgroups are inappropriate, but he ignores
us all.

Glad to see you're not interested in using a service that has to attract
business using such questionable practices.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Abe" wrote in message
...
I was under the impression that commercial solicitations
were not allowed on these Groups. But I could be wrong
So, being that its ThanksGiving wekend here in Canada,
I will say thanks, but I'm not interested.


"PC Datasheet" wrote in message
link.net...
Contact me at my email address below if you would like some help with
your
database. My fees are very reasonable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"Abe" wrote in message
...
I am having a dilemma with a Hotel Booking Project which is
a small part of a larger project.
If someone can help me with this, or refer me to a sample DB
it would be seriously appreciated!

I have my tables set up as follows.
tblMembers one to many tblHotelBookingsToMembers
tblHotelBookings one to many tblHotelBookingsToMembers
(This is setup in the same manner as the Products, Order Details,
Orders tables in the Northwind DB)

In the tblHotelBookings I have fields to capture Number of Nights,
& Persons for each booking
If two members are staying in the same room,
I book them each individually under the same HotelBooingID
in tblHotelBookings
So let's say that HotelBookingID 1001 has 3 Nights & 2 Persons.

Because each member (John & Mary) is linked to HotelBookingID 1001,
when I try to create a report or query, that sums the number of room
nights
and persons, I get duplicate values. 6 nights & 4 persons

Essentially I am trying to figure out how I can book two Members into
the same hotel (specific room #s aren't captured) so that each member
has
a booking in my DB and I can design a report that will show the number
of
persons & nights for each booking without duplicates. This info has to
be
passed on to the Hotel.
Lets see if I can be more clear...
If one member (John) is booked, but has a second person (i.e. Spouse)
staying with him who is NOT a Member, then I do NOT need to
show a booking for that second person in my DB.
I simply indicate 2 persons. So I only have ONE booking. No problem.
But if his spouse is a member then I must also book that person into
the
DB,
which creates 2 members for the same HotelBookingID

Any advice or help is welcome!
Thank You!

PS: If more clarity is needed, feel free to indicate so.