PLEASE--Need help with my query coding..

[KimHuff]

Well, I just cant figure out what I am doing wrong so I hope someone here can help me.

I have a rather small database with the following fields

ID
NonPublished
StudentLastName
StudentFirstName
Address
Address2
Zip
HomePhone
Parent1LastName
Parent2FirstName
Parent2LastName
Parent2FirstName
GradYear

I am trying to create an expression for the Parents that will combine the parent fields so they will display a certain way. For example.. lets say that you have the following...

Parent1LastName: Huff
Parent2FirstName: Kim
Parent2LastName: Huff
Parent2FirstName: Larry

As long as the last names match, I would want that to display as Kim & Larry Huff

BUT, lets say you have this...

Parent1LastName: Stanley-Huff
Parent2FirstName: Kim
Parent2LastName: Huff
Parent2FirstName: Larry

I would want that to display as Kim Stanley-Huff & Larry Huff

AND, if there is only one parent listed...

Parent1LastName: Huff
Parent2FirstName: Kim
Parent2LastName
Parent2FirstName

I would want it to display as just Kim Huff.

I have tried to get this to work without much luck.

Does anyone have any suggestions on what would allow me to receive my desired output?

Thank you in advance,

Kim

 

[namliam]

http://www.access-programmers.co.uk/forums/showthread.php?t=180372