A reporter has to make reports to his boss of having sex with a woman of every zodiac. At the end he has one last zodiac to have sex with and it winds up being his boss's wife. It was a comedy as far as I know. I saw it on cable around 1982 or 83. I only saw it once but never knew the title

There's a TV series called Mr. Yogi about a man trying to find a wife by dating a girl from each astrological sign - it aired in the late 80's... there is also a newer movie called 'What's your Raashee' (2009) that has the same premise... both are based off the book 'Kimball Ravenswood', maybe that's what you're looking for?

http://en.wikipedia.org/wiki/Mr._Yogi_(TV_series)
http://www.imdb.com/title/tt1242530/
http://www.imdb.com/title/tt1242530/board/flat/148182273?p=1