sex during pregnancy

I feel like I'm the only one who is never in the mood when pregnant.  My husband gets frustrated and distant because of it which pisses me off.  I'm not good at faking being in the mood and if I do it just to appease him he's pissed at that too.  Anyone else have this issue or have any suggestions for me?  This is our second baby and I can't deal with his moodiness the next 6 months.