Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating Table or CTQuery w/multiple criteria
It worked! I had to change the else part of the statement to a zero instead of a blank and sum so that states with more than one program would show all funds for all categories in one record. I had tried quite a few IIf statements that were much more involved but didn't work. I knew it had to...- Boncher
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Creating Table or CTQuery w/multiple criteria
I have a table that contains four yes/no fields to designate four different program types (NBUG, NBGRAD, NNBUG and NNBGRAD). Some programs have more than one type, so the XYZ Program may have a yes for NBUG and NBGRAD. I need to create a query (hopefully a cross tab) or a table that has the...- Boncher
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
