Tilted Forum Project Discussion Community - View Single Post

RAGEAngel9 · 04-25-2005, 12:52 PM

I'm working a access thing for work and I can't figure out the correct way to get the data I need out of a table.
I have a table with a bunch of fields including year, yesNo1, yesNo2, yesNo3, and yesNo4. I want to count up all the occurances of each yesNo# in 2005 or later (obviously nothing later yet). I can't figure out how to do this. I can get the individual counts, but not a combination of them. I need the counts to put into a report.

I'm not that great with SQL and no very little about VB.
(I got stuck with this, because we are light on work this week

)

Anyway suggestions?

Side question:
As I need to get something resembling a working knowledge of VB, what is a good resource. I find MS.com to be more of a pain, and googling hasn't given me anything comprehensive yet.

Thanks.

04-25-2005, 12:52 PM	#1 (permalink)
RAGEAngel9 Insane Location: Vermont	MS ASSESS / SQL Question I'm working a access thing for work and I can't figure out the correct way to get the data I need out of a table. I have a table with a bunch of fields including year, yesNo1, yesNo2, yesNo3, and yesNo4. I want to count up all the occurances of each yesNo# in 2005 or later (obviously nothing later yet). I can't figure out how to do this. I can get the individual counts, but not a combination of them. I need the counts to put into a report. I'm not that great with SQL and no very little about VB. (I got stuck with this, because we are light on work this week ) Anyway suggestions? Side question: As I need to get something resembling a working knowledge of VB, what is a good resource. I find MS.com to be more of a pain, and googling hasn't given me anything comprehensive yet. Thanks.