Wedding query blues!

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

Hi,

I'm creating a database to manage an upcoming wedding. I've entered each
individual attendees details into a table called tblPeople: FirstName,
Address1, PostCode etc...

What I'd like to do is create a query listing names of people at the
same address so that I can later create a label report or thank you
notes but I'm stuck how to create the query. Would I have to create two
queries - one for male & one for female at the same address and then
link them some how???

I'm quite new to this so if it's really obvious let me apologise in advance.

Thank you

Lee Kennedy
 
John said:
Lee-

Take a look at the WeddingList database on my website:

http://www.viescas.com/aftp/Download/Wedding.zip

It's in '97 format, but you can convert it to a later version if that's what
you have.

Thanks John, and I have your book Access 2003 inside out - very informative!

If I wanted to track more than the wedding itself, Reception, Vows, Hen
night stag night etc... and invite different people to different events
how would I write the query to allow me to concatenate names from the
same address?

Lee
 
Lee-
Take a look at the WeddingList database on my website:

http://www.viescas.com/aftp/Download/Wedding.zip

It's in '97 format, but you can convert it to a later version if that's what
you have.

Thanks John, and I have your book Access 2003 inside out - very informative!

If I wanted to track more than the wedding itself, Reception, Vows, Hen
night stag night etc.... and invite different people to different events
how would I write the query to allow me to concatenate names from the
same address?

Lee
 
Lee-

Apologies for the tardy reply, but I've actually been mulling over how to
solve this efficiently in my spare time. You'll certainly want an "events"
table to track all the goings-on -- bridal showers, Hen night, Stag night,
rehearsal dinner, wedding, and reception. The trick is some people will be
invited to some but not all events, and you want to generate a "joint"
invitation when appropriate. (Jane Doe is invited to Hen night, John Doe is
invited to Stag night, and Mr. & Mrs. John Doe are invited to the wedding
and reception.)

One technique would be to allow both individual and "group" entries in your
Invitees table. You could have the table reference itself with a "member
of" field. However, that would also imply some data redundancy because you
would have the name and address info for the "Doe" family in three records.

But trying to assemble individual records into a single invitation using a
query could be difficult. How do identify the duplicates? By last name?
(Some couples have different last names.) By address? (You would have to
be careful to enter the address exactly the same in multiple records.)

Feel free to write to me directly - JohnV at viescas dot com. If we can
hammer out a solution, it could make an interesting version of the Wedding
database in my next book. <s>

--
John Viescas, author
"Building Microsoft Access Applications"
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top