Reports

[Warrren]

I have a report that gives the wedding anniversary dates for the current
month which is great. The problem is that it shows husband on one line and
wife on another. How can I combine the two chirstian names so that I get
something like this:
27- Jan-35 Willian & Janice Smith, instead of,

27- Jan-35 Willian Smith
27- Jan-35 Janice Smith

Tank you in advance

 

[Warrren]

Thanks Duane,
I can understand what you mean but each time I try I get syntax wrong I am
including a copy of the the query in this message using this query I get the
husband on one line and the wife on the second line how do I get all the
details on one line?

SELECT DISTINCTROW Members.FirstName, Members.LastName,
Members.WeddingAnniversary, Household.Address, Household.City,
Household.StateOrProvince, Household.PostalCode, Household.HomePhone FROM
Household INNER JOIN Members ON Household.AddressID = Members.AddressID WHERE
(((Month([WeddingAnniversary]))=Month(Now())));

Thanks once again for your prompt reply i am still learning Access. Warren

 

[Duane Hookom]

Thanks for the reply. We are here to help where we can.